Is there is any way to know number of spindles present in the HardDisk?

• Marimuthu-129612

  Hall of Fame

  Points: 3332

  More actions

  May 23, 2005 at 12:40 am

  #86398

  Hi All,

   What are the different possible methods to find the number of spindles present in the HardDisk? 

   any extended stored procedure ??

• Helen-84411

  Hall of Fame

  Points: 3320

  More actions

  May 23, 2005 at 2:21 am

  #560436

  Hi,

  It's part of Hardware details ask your vendor about it. Try to find it from regeistry

  
  Helen
  --------------------------------
  Are you a born again. He is Jehova Jirah unto me

• Richard L. Dawson

  Ten Centuries

  Points: 1062

  More actions

  May 24, 2005 at 7:22 am

  #560746

  Only your vendor knows for sure.

  If you built it from parts you will have to contact the hard drive manufacturer and get the specs from them.

  You asked about an extended procedure. As in Extended Stored Procedure? There is no way that the Sql Server will be able to pull this information up.

  You may be able to get to it with a WMI script. It is designed for this sort of thing.

  However, the easiest way is to contact the vendor of the hardware.

  

   

  Richard L. Dawson
  Microsoft Sql Server DBA/Data Architect

  I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.