April 28, 2009 at 1:22 pm
I was trying to get some data from perfmon re: sql server, and i'm seeing the object being different
What I THINK I'm seeing here is that if there is a non-default instance name associated with the database its MSSQL$
Is that correct? I wonder why they wouldn't just use MSSQL$
So my questions,
1) Is my assumption here correct?
2) Is this true of all versions of sql server (sql 2000 and up)
Heres a bit of the digging I did on it:
We have a clustered SQL 2005 std database with an instance name
I open perfmon and connect to the servername
MSSQL$
MSSQL$
etc
I then connected to a non-clustered database (SQL 2005 std again) (default instance)
SQLServer:Locks
SQLServer:Latches
So..
I connected to a sql 2000 server with an instance..
MSSQL$
MSSQL$
again..
so I try a default instance on sql 2000 and im back to
SQLServer:Locks
SQLServer:Latches
Thanks guys and gals! 🙂
--------------------------
I long for a job where my databases dont have any pesky users accessing them 🙂
April 28, 2009 at 4:04 pm
So my questions,
1) Is my assumption here correct?
2) Is this true of all versions of sql server (sql 2000 and up)
1. You assumptions are correct. Named instance perfmons show as MSSQL$INSTANCENAME.
2. This is true of SQL 2000 and 2005. I would assume it's true of 2008 but I don't have any named instances to check.
April 29, 2009 at 7:39 am
Thats what I figured..
Thanks Edogg.. appreciate you taking the time to answer! 🙂
--------------------------
I long for a job where my databases dont have any pesky users accessing them 🙂
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply