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 |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2005-03-09 : 11:04:59
|
| I found this select statement either here or from some other sql related site. It runs like charm from my QA until this morning. It did not error out, but just did not return anything. I could obtain the connection count some other ways, but I am curious about what kind of setting change could cause this.SELECT [UserConnections] = cntr_valueFROM master..sysperfinfo PageSplitsSec (nolock)WHERE (object_name = 'SQLServer:General Statistics' AND counter_name = 'User Connections' AND instance_name = '') |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-03-09 : 11:33:06
|
I don't know. That statement works on the server I happen to be on now. Have you tried something like this just to see if the values have change for Object_Name or Counter_Name?SElect Object_name ,counter_name ,count(*)FROM master..sysperfinfo PageSplitsSec (nolock)group by Object_name ,counter_name Be One with the OptimizerTG |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2005-03-09 : 11:44:20
|
| No, I have not. I am not good at querying those system settings. I tried your script, and nothing came back.I noticed another change. The performance monitor on the server also failed to show it. As a matter of fact, I could not see any performance object starting with SQL Server, such as SQL Server General statistics, or SQL Server Buffer. The only change we had last night is to alter database' tempdb from c to another drive with larger space.Could that caused this?The server runs fine. Thanks! |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-03-09 : 11:56:17
|
| sysPerfInfo is a virtual table so its only in memory. Didn't you also have that Buffer Latch error recently? Sounds like you've got some memory issues going on. I don't know, you might want to open a ticket with M$.Be One with the OptimizerTG |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2005-03-09 : 14:14:40
|
| Yes, we did run out of space on tempdb ( size 30 mg, 10% auto growth), and believe that caused the buffer latch error. When we rebooted during the night, the server recovered to 100%. And that is why we moved the tempdb to another dirve. I need to find out what other master..sys table is "missing". Thanks! |
|
|
|
|
|
|
|
|
check No of user connection