Profiling to collect data as quickly as possible to trace server activity!

• Karine-118992

  SSC Journeyman

  Points: 90

  More actions

  April 7, 2008 at 10:10 pm

  #121228

  Need to use Profiler to collect data about server resources for capacity planning. Any idea on the event selection to use?

  thanks for sharing your tips

  Karine

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  April 8, 2008 at 9:18 am

  #799843

  I'm not sure I'd use profiler for capacity planning. I think System Monitor from Windows would be better.

  http://www.mssqltips.com/tip.asp?tip=1267

  http://msdn2.microsoft.com/en-us/library/ms978394.aspx

• Karine-118992

  SSC Journeyman

  Points: 90

  More actions

  April 8, 2008 at 10:43 am

  #799894

  Yor are right, but because I needed to automate the collection process and gathered info as quickly as i can, Profiler is the best tools and I find the answer , the following are the events I used to collect my data:

  TSQL event classes

  SP:CacheHit and SP:CacheMiss event classes

  Scan:Started and Scan:Stopped event classes

  Lock:Acquired and Lock:Released event classes

  Lock:Deadlock Chain, and Lock:Timeout event classes.

  Thanks for your time S!