SQL Server, PASS, and other data mishaps
Posts tagged Rant
99 problems and the disk aint one
May 2nd
Its Meme Monday again and this time Tom has picked an interesting topic.
How many problems do we all see in our shops that arent related to disks? Since disk related issues would normally be my #1-10 I guess Ill have to start at #11
.
11. ESX misconfigurations
12. Old DBMS Version requirements from vendors
13. Bad DB design
14. Active Directory
15. Network connectivity/configuration
16. JAVA
17. Security architecture & design
18. Vendor Code…
19. Overly complex solutions to satisfy edge cases
This is my list of 9, What are yours?
Ill go out on a limb and tag 3 people
Lori Edwards, you havent written a blog post lately, consider this your invitation
SQL/Windows Clustering Stupidity
Feb 18th
When is high availibility not?
When its any version of SQL running on a clustered Windows 2003 Server or sql 2005 running on clustered Windows 2008 Server. Seems that while you can dynamically add a disk and use it in SQL when your running a standalone server, if your running in a “highly availiable” cluster configuration you have to take SQL offline to add the disk as a dependency in order to be able to use it within SQL. Here’s the proof right from SQL books online.
Im sure there was a good reason to require this at the time but clearly this wasnt thought out in the grand scheme of taking 0 downtime. Anytime a single server has a more highly availiable architecture than your system that is designed for high availibility –>youre doing it wrong, Sorry someone had to say it
