February 8, 2010 at 2:42 am
Dear All,
I want to set up a counter log. But I am not able to see any SQL Server items(SQL Server:Buffer manager etc.) in Performance object combo box.
Why.? I am doing it in a remote pc. logged in as Administrator.
Wot could be the problem.?
Thanks in advance.
February 9, 2010 at 5:40 pm
Are you able to see any performance info when querying:
select * from sys.dm_os_performance_counters
?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 10, 2010 at 10:37 am
Hi Joy,
I had this happen recently on a SQL Server 2000 instance. The error log had this line shortly after the database engine was started:
2010-01-27 09:24:36.35 server Performance monitor shared memory setup failed: -1
I don't know what the cause was - if you find out, I would quite like to know. :hehe: I resolved the issue by restarting the instance.
This line (which comes after the startup database recovery messages in the log file) seems to indicate that the PerfMon metrics are being populated:
2010-02-09 17:04:56.98 spid3 SQL global counter collection task is created.
This message comes from the SIGNAL HANDLER system process.
HTH
February 10, 2010 at 10:25 pm
Thanks for the reply. It's SQL Server 2005.
Infact we had even restarted the server, but still it's not appearing. Will let you know if I get any solution.
February 10, 2010 at 10:42 pm
Are you able to get any results from the database query i provided?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 15, 2010 at 10:20 pm
Some problem at client place. Not able to get remote connection. Will check once it's connected. Wel, Wot if we dont get any records from the query you provided ..? Can you please explain..?
Thanks.
February 15, 2010 at 11:32 pm
It could be an indicator of insufficient permissions.
Hopefully you are able to retrieve results. If you can get results, then you have an alternative method to get your perf counters.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply