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 |
|
GaryF
Starting Member
4 Posts |
 Posted - 2009-04-02 : 15:01:42
|
| My master..sysperfinfo isn't getting up to date info. It's not empty but it's not current either. I've asked on Experts Exchange, MSDN Technet, etc. but no answers. Hopefully I'll have better luck here.Any ideas?Saving the world one database at a time! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-04-02 : 16:27:58
|
| what do you mean it's not getting up to date info?the values there are aggregated since the instance started.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.5 out! |
 |
|
|
GaryF
Starting Member
4 Posts |
Posted - 2009-04-02 : 17:01:07
|
| For example, when I run perfmon on the server, it shows 2 logreader agents. when I look at the sysperfinfo table it shows 2 logreader agents (makes sense because it's where perfmon gets it's info). However, when I look at MSSQL replication monitor or tempdb..MSreplication_agent_status there are actually 16 logreader agents running.My question is, why doesn't sysperfinfo show the 16 that are running? Saving the world one database at a time! |
|
|
|
|
|
|
What updates sysperfinfo?