exec sp_datatype_info and EXECUTE msdb.dbo.sp_sqla | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

exec sp_datatype_info and EXECUTE msdb.dbo.sp_sqla

Hi All, I have a trace table.
I analysed the data to see the longrunning stored procedures. The ones that take a lot of time are the following.
EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters. exec sp_datatype_info 0. My question is why are this two system stored procedures executed?
and who use them? My applications uses an ODBC connection.
And I have some demo alerts defined on the sql server. Thank u for your help.

sp_datatype_info
Returns information about the data types supported by the current environment. Check this
http://www.sql-server-performance.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=1288 —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka

The stored procedure msdb.dbo.sp_sqlagent_get_perf_counters is the system SP which feeds the alert for SQLAgent service. If you want to change the interval of this alert you can modify the registry or if you want to avoid the alerts then remove all the alerts set under SQL Server management –> sqlagent –> alerts. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />The stored procedure msdb.dbo.sp_sqlagent_get_perf_counters is the system SP which feeds the alert for SQLAgent service. If you want to change the interval of this alert you can modify the registry or if you want to avoid the alerts then remove all the alerts set under SQL Server management –&gt; sqlagent –&gt; alerts.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Hi Satya'<br /><br />Thank u for your help.<br />I see the following alerts<br /><br />Alert name<br />Demo:Full msdblog<br />Demo:Full tempdb<br />Demo<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />ev.19 Errors<br />Demo: Sev.19 Errors<br />Demo: Sev.19 Errors<br />Demo: Sev.19 Errors<br />Demo: Sev.19 Errors<br />Demo: Sev.19 Errors<br /><br />My question is. <br />Are these alerts installed by default by SQL SERVER and what are the consequences if I delete them?<br /><br />thanks
Check out the link refrenced by Dinesh. You shouldn’t see any issues when you delete those alerts. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

Nothing adverse happened on my SQL servers when they are deleted, but ensure the alerting is working after deletion by created a realtime required alert. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
…just for the overly cautious ones. A current backup (including system db’s) never hurts. [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
]]>