RSS registrovat login
Navigace: předchozí stranaúvodní strana
SQL2008 - problem with Activity monitor

I had some problem with SQL2008 Activity monitor (tool that shows some usefull information like cpu usage, database I/O etc). When I tried to open it, I received the following message:

===================================

The Activity Monitor is unable to execute queries against server ServerName.
Activity Monitor for this instance will be placed into a paused state.
Use the context menu in the overview pane to resume the Activity Monitor.

===================================

Kategorie neexistuje. (System)

------------------------------
Program Location:

at System.Diagnostics.PerformanceCounterLib.GetCategorySample(String machine, String category)
at System.Diagnostics.PerformanceCounterCategory.GetCounterInstances(String categoryName, String machineName)
at System.Diagnostics.PerformanceCounterCategory.GetInstanceNames()
at Microsoft.SqlServer.Management.ResourceMonitoring.SqlPerfmonProcessReader.get_CpuCount()
at Microsoft.SqlServer.Management.ResourceMonitoring.SqlPerfmonProcessReader.GetSqlProcessCpuUtilization()
at Microsoft.SqlServer.Management.ResourceMonitoring.BackgroundSqlCpuTask.Execute()
at Microsoft.SqlServer.Management.ResourceMonitoring.BackgroundWorkRequest.Execute()
at Microsoft.SqlServer.Management.ResourceMonitoring.BackgroundWorkRequestQueue.BackgroundWorker_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)


note: message "kategorie neexistuje" means "category does not exist" in english.

Reason
What is the reason? AM uses preformance counter but some of them disappeared on my computer (actually, there were disabled), so values could not be read by AM and caused exception. When I run the perfmon tool, I did not see some counters like "processor".

Solution
I found some information on MS site - see Troubleshooting Performance monitoring (there is also czech version). All I really did was that I found all keys in system registry with name "Disable Performance Counters" and changed their value from 1 to 0. After that, I can see the "processor" counter again and AM start working after restart of Management studio, it did not work before restart.

Informace ke stavu builder.cz zde


vytvořil Mi.Chal. 15.5. 2009 22:16, naposledy změněnil Mi.Chal. 15.5. 2009 22:50
přečteno: 4055x

Komentáře:
Žádné komentáře dosud nebyly vloženy.

Přidat komentář:
Jméno
E-mail
Web
Titulek
Obsah
thomas sabo rea mbt outlet thomas sabo charms sale louis vuitton taschen kaufen thomas sabo boutique mbt kaufen