[dba-SQLServer] Suddenly I can see

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.

-- 
John W. Colby
www.ColbyConsulting.com
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com