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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-29 : 10:10:10
|
| Sundar writes "Hi,I am trying to figure out a way to catpure the output of sp_user_counterX stored procedure created in master database using perfmon. I am using SQL 2000 in Windows Advanced Server environment. In SQL 7.0, perfmon was using the built in account "probe" to execute the stored procedure and it is not supported in SQL 2000. Any thought/ideas how to find a work around for this ?ThanksSundar" |
|
|
RocketScientist
Official SQLTeam Chef
85 Posts |
Posted - 2001-11-29 : 14:35:54
|
| You should be able to do this using performance monitor to log the performance statistics. In Windows 2000, you can use Performance Monitor, open the "Performance Logs and Alerts" item in the left-side of the window, and choose "Counter Logs". You can set up counter logs to log whatever you want, including your own counters, and write it into a comma-separated file. If you need the data to be put back into SQL Server for analysis, you can BCP it in. If you're using Windows XP, you also have the option of directly logging the data to a DSN into a database, but I have no idea how to set up the tables to make that work.-rs |
 |
|
|
|
|
|
Perfmon with SQL 2000