What is equilent to statspack for sql server 2005 ???

• jagpalsingh4

  Ten Centuries

  Points: 1311

  More actions

  April 7, 2008 at 9:05 am

  #186121

  hi,

  will u plz tell me is there is any query for sql server like in oracle we use statspack to see database stats .plz tell me how can we see database stats in sql server .

  thaxxx

• GSquared

  SSC Guru

  Points: 260824

  More actions

  April 7, 2008 at 12:08 pm

  #799321

  I think what you're looking for is SQL Server Profiler. You might check that out and see if it will do what you need.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon