[dba-SQLServer] Suddenly I can see

 > Ouuuu... new toys. 8-) Jim

LOL, Yep!  8-)

PRETTY new toy!

John W. Colby
www.ColbyConsulting.com


Jim Lawrence wrote:
> Ouuuu... new toys. 8-) Jim
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Friday, July 09, 2010 12:07 PM
> To: Access Developers discussion and problem solving; VBA; Sqlserver-Dba
> Subject: [dba-SQLServer] Suddenly I can see
> 
> I bought a nice little (big actually) 4U rack mount case for my SQL Server,
> the new widget I am 
> building.
> 
> The cool thing about this case is that it uses 20 hot swap disk sleds, and
> they have a very neat 
> little light pipe system to display the power and activity on each disk.
> The disk sleds plug in to 
> a backplane, and on that backplane are a green power and blue data LED.
> There are two clear plastic 
> light pipes along the side of the sled which pipes the light to the front so
> it can be seen.  Really 
>   cool I thought.
> 
> What this means to me is that for the first time I can actually see which
> disks are in use.  The 
> server "lights up like a Christmas tree" when stuff is actually written to
> disk.
> 
> I am now able to actually compare the screen as I run processes, and watch
> the lights and I'm here 
> to tell you, my disks are not the bottleneck.  SQL Server will process for
> many seconds and then a 
> burst of disk activity a half second long, then many seconds of crunching,
> then a half second of 
> disk activity.
>