June 23, 2009 at 9:56 am
This is killing me really. sometimes i see some users(she is sysadmin) active sessions in the activity monitor for a particular database but there wont be anything running for the user in real on that database. when i thought tracing that session in quest spotlight i found the following query for that user
-- page grid storage: get range [25,51]
select l.* from #snapshot_processinfofltr l, #snapshot_processinfofltr_sortedindex p
where p.[Range] >= 25 and p.[Range] <= 51 and p.[ROW ID] = l.[ROW ID]
order by p.[Range][/quote-0]
what does it mean and why is it running undera user database. this is just an example but i see many times such thinngs in the activity monitor even for my self. Though i dont run any query but still i see a session running under my login for a user database.
Can someone explain me about the sql server reacting this way.
June 23, 2009 at 10:04 am
What else is shown in Activity Monitor? What application is shown for that particular process id?
What you are seeing could simply be normal, behind the scenes activity of tools such as SSMS, BIDS, even Activity Monitor. What you are chasing could simply be much ado about nothing. Unless it is causing problems with your system I'm not sure I would chase everything you see. Just MHO.
June 23, 2009 at 10:31 am
It is shown as MS SQL Server Mgmt Studio in the activity monitor.
I understand, un less we have any problems it should be OK but how should i explain my boss, he keeps asking me why is that showing there when there is no process running with that login id?
June 23, 2009 at 10:48 am
One of the beauties of working with a GUI tool like SSMS. It does things behind the scenes to make our jobs easier. It monitors the status of the SQL Server systems registered seeing if they are started or stopped (green light/red light), the various objects in each of the databases (tables/views/stored procedures/functions/etc).
Does your boss expect you to understand the all the inner workings of SSMS? What it is doing at all times? I'm not sure anyone other than the developers of SSMS actually do. I also don't think BOL tells us much in that regard either.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply