How do you determine the number of storage arrays for a SQL instance?

Question

How do you determine the number of storage arrays for a SQL instance?

dbajunior

SSCrazy

Points: 2307
More actions
September 20, 2011 at 10:34 am

#245233

We are trying to set up SQL warning/critical some alerts in a monitoring tool. Some settings, such as Queue Length, specify the Warning level should be 5 * number of arrays. How do I determine that number? (I'm pretty new to this).

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

okbangas SSChampion Points: 11773 More actions · Answer 1

Basically: There is no way to do so. And, disk queue length is among the performance counters I rarely use. I would recommend that you take a look at Brent Ozars How to prive it's a SAN problem[/url], which gives some useful information.

Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

Concatenating Row Values in Transact-SQL[/url]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

dbajunior (9/20/2011)
Some settings, such as Queue Length, specify the Warning level should be 5 * number of arrays. How do I determine that number? (I'm pretty new to this).

Disk Queue length is pretty meaningless, has been for years especially with SQL Server

http://blogs.msdn.com/b/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx

http://sqlblogcasts.com/blogs/simons/archive/2007/11/16/SQL-Server-Myths---Disk-Queue-length-a-bit-like-buying-Guiness.aspx

"Deja q?": The feeling that you've already answered this question today.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass