January 17, 2011 at 9:29 am
Why do I see SQLDMO entries in profiler like
select (sum(size) * (8192/1024)) / 1024 from dbo.sysfiles WHERE (status & 0x40) <> 0
and
select @dbsize = sum(convert(bigint,case when status & 64 = 0 then size else 0 end)) , @logsize = sum(convert(bigint,case when status & 64 <> 0 then size else 0 end)) from dbo.sysfiles
There is no other activities going on in the database besides these DMO statements showing up.
Thanks.
January 17, 2011 at 11:50 am
Do you have some sort of monitoring software? That looks like some sort of standard maintenance script. Check for scheduled jobs or monitoring software.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 17, 2011 at 12:28 pm
The application name is showing "SQLDMO_1", but in this case it is not related to management studio. There are no monitoring services running.
Thanks.
January 17, 2011 at 12:53 pm
Why do you think it's not related to management studio? The queries are retrieiving the amount of space available. Couldn't someone be running one of the standard reports from SSMS to retrieve this. I'm inclined to think that's what you're seeing.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 18, 2011 at 6:34 am
Digging further into this, I found out that a monitoring service is running. Thanks for your help.
August 31, 2011 at 5:34 pm
I'm curious as to what monitoring system you found running? I'm getting ready to retire a server and while profiling some of the databases to determine usage, I found this same query is showing up in all of them. It's running hourly, with the ApplicationName of SQLDMO_1.
I can't find anything running in the Database or in Scheduled Tasks. I also can't find this query in the sprocs anywhere on the system, or in any of the job steps. I'm a little mystified! I'm profiling two other servers for retirement and this isn't going on there. We do have MOM running on all the servers.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply