Red Gate forums :: View topic - Repeating LRQ Alert that persissts (ACTIVE) All day long
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Repeating LRQ Alert that persissts (ACTIVE) All day long

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Tue Nov 06, 2012 6:45 pm    Post subject: Repeating LRQ Alert that persissts (ACTIVE) All day long Reply with quote

Does SQL Monitor raise an LRQ Alert on the Stored Procedure ‘sp_trace_Getdata’ for you? It does for us and not only one LRQ but 2 HIGH level LRQ alerts which persist at an ACTIVE status all day long and re-appear each and every day. In short this is an LRQ that never ends. It goes to an inactive status only when the SQL Server hosting the DB’s is restarted/rebooted. But as soon as the server is back up and 120 seconds have passed these same 3 LRQ alerts re-appear.

Does anyone else find this odd? Have you had run-ins with this SP?
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 924
Location: Red Gate Software

PostPosted: Wed Nov 07, 2012 9:54 pm    Post subject: Reply with quote

Hi

Thank you for your forum post.

sp_trace_Getdata is used by SQL Profiler. Do you have the trace feature of SQL Monitor enabled (which is running SQL Profiler to obtain the trace data)?
Or are you or a colleague been running SQL Profiler outside of SQL Monitor to collect information and forgotton to turn off the SQL Profiler?

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Tue Nov 13, 2012 6:22 pm    Post subject: Re: Reply with quote

eddie davis wrote:
Hi

Thank you for your forum post.

sp_trace_Getdata is used by SQL Profiler. Do you have the trace feature of SQL Monitor enabled (which is running SQL Profiler to obtain the trace data)?
Or are you or a colleague been running SQL Profiler outside of SQL Monitor to collect information and forgotton to turn off the SQL Profiler?

Many Thanks
Eddie


No we are not using profiler and the 3 instances of this LRQ alert being captured dialy are not the default background trace that SQL Server runs; in other words the id from sys.TRACES is not 1.

I suspected this was asscoaited with tracing. Are no other SQL Monitor users reporting that their SQL monitor is seeing an LRQ alert for this same thing? I'm %99 certain its Sharepoitn specific menaing you have to be monitoringa SQL Server instance that hosts SharePoint DB's. Being that Red-gate develops tools for Sharepoint I would think you'd (or someone in a SP team at Red-gate) have some insight into this.

Thanks
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 924
Location: Red Gate Software

PostPosted: Thu Nov 29, 2012 9:41 pm    Post subject: Reply with quote

Thank you for your reply and sorry for the delay in replying.

You wrote:
Quote:

Being that Red-gate develops tools for Sharepoint I would think you'd (or someone in a SP team at Red-gate) have some insight into this.


I am not aware of any tools that Red Gate develops specific for Sharepoint servers. There are a couple of ANTS profiling tools that can profile .NET applications for Sharepoint. There is also a use case with SQL Virtual Restore Sharepoint Object Level recovery with Metalogix Selective Restore Manager.

Are there any other SQL Monitor users monitoring SQL Servers / Sharepoint servers experiencing this problem?

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Tue Dec 04, 2012 8:51 pm    Post subject: Re: Reply with quote

eddie davis wrote:
Thank you for your reply and sorry for the delay in replying.

You wrote:
Quote:

Being that Red-gate develops tools for Sharepoint I would think you'd (or someone in a SP team at Red-gate) have some insight into this.


I am not aware of any tools that Red Gate develops specific for Sharepoint servers. There are a couple of ANTS profiling tools that can profile .NET applications for Sharepoint. There is also a use case with SQL Virtual Restore Sharepoint Object Level recovery with Metalogix Selective Restore Manager.

Are there any other SQL Monitor users monitoring SQL Servers / Sharepoint servers experiencing this problem?

Many Thanks
Eddie


Eddie,

I believe we've tracked down the problem and its a monitoring feature that SharePoint is using/running. I'm not that involved with the Sharepoint administartion so I can't give any more details other then to say the Sharepoint admin is running some kind of monitoring that comes with Sharepoint and they identified it as the cause based on the time this alert atsrts up every day on SQL Monitor. I have another LRQ related issue like this that is not Sharepoint related but will post it in a seperate posting.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group