Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlzagi
Starting Member
11 Posts |
 Posted - 2007-04-30 : 11:25:10
|
| Hi,Is there possibility to get somehow statistic for mostly used SPs in the SQL Server 2000 Database? Any field in sysobjects for number of executions for certian SP?Thanks,sqlzagi |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-04-30 : 12:39:51
|
| AFAIK sql 2000 doesn't have anything like that._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-30 : 12:56:17
|
| We use SQL Profiler, store the results to a Table, manipulate the "Text data" somewhat (to allow better aggregation of queries), and then do Stats from that.Kristen |
|
|
|
|
|
|
Statistic for heavilly used SPs