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 |
|
thombeaux
Starting Member
18 Posts |
 Posted - 2007-05-31 : 15:28:21
|
| Our production machine's master..syssperfinfo table is empty, no records.What could have caused this?Thanks and God Bless,ThomBeauxThomBeaux |
|
|
thombeaux
Starting Member
18 Posts |
Posted - 2007-05-31 : 15:36:09
|
| It is also missing from perfmon on that machine (64-bit SQL Server 2000 SP3a).How do you get it back?ThomBeauxThomBeaux |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-31 : 17:07:55
|
| Rebooting can fix it usually. |
|
|
|
thombeaux
Starting Member
18 Posts |
Posted - 2007-06-01 : 09:03:45
|
| Ran the following:Reload the SQL counter objects (in Command Prompt):a) unlodctr mssql (eg. unlodctr mssql$sql2k)b) lodctr C:\Program Files\Microsoft SQL Server\mssql \Binn\sqlctr.inic) restart SQL Server serviced) check perfmon and make sure SQL counter objects are presente) run from SQL QA: select * from master..sysperfinfoThomBeaux |
|
|
|
|
|
|
master..sysperfinfo...