May 19, 2005 at 10:21 am
Hidely ho!
A little background: I have SQL 2000 running on a Windows 2000 machine. Being new to this company, I was not around for the installation of either.
The problem: I am attempting to tune and optimize each SQL server here which has been long and arduous but rewarding. It is so nice to see the little users faces when you bring 4-5 runtimes down to under a minute. Anyway, I have run into a server that will not allow performance monitoring.
Looking into the syspefinfo table, I found no data. This is not a clustered server and the login is not the problem. I just have no counters from which my programs can grab performance data. I went through the MS data and am currently going over what I have found there.
My question is: has anyone here run into this? If so, what did you do to fix it? Also, what would be the purpose in disabling these counters?
A big thanks in advance!
May 19, 2005 at 11:13 am
Steve,
Take a look at this thread -
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=124868
Steve
May 19, 2005 at 12:12 pm
Hi,
1. Can you see SQL performance counters in System Monitor?
OR
2 Download Scriptomatic tool from Microsoft website
Run it (scriptomatic.exe), it will unzip the following files: scriptomatic.hta and "Write WMI Scripts Like the Pros.doc"
Double-click on scriptomatic.hta, it will open like a screen with "Begin By Selecting a class" dropdown. Click on it. Scroll to the middle. See if
WIN32_PerfRawData_MSSQLSERVER.... performance SQL classes are there
Click on any SQL Server class. Click Run button. Can you see results?
Regards,Yelena Varsha
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply