I would like to know what could be the possible issues if i disable all the alerts(that come in by default) in Sql server. This is important since disabling these alerts is improving the performance by a huge amount.
I am talking about the demo alerts that come by default . viz - Demo: Full msdb log Demo: Full tempdb Demo: Sev. 19 Errors Demo: Sev. 20 Errors Demo: Sev. 21 Errors Demo: Sev. 22 Errors Demo: Sev. 23 Errors Demo: Sev. 24 Errors Demo: Sev. 25 Errors I want to disable the proc sp_sqlagent_get_perf_counters by setting the PerformanceSamplingInterval in registry as 0. There are no other user defined alerts.
Run SQL Server Enterprise Manager. Expand a server group; then expand a server. Expand Management; then expand SQL Server Agent. Double-click the appropriate alert to see if the alert is enabled. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
I am seeing these errors as well. Does that mean the error never fired if in the LAST OCCURRED column it says NEVER OCCURRED? This would be a good sign right? Company is on SQL 7 For the top msdb and tempdb erros they have an Error of 9002 Thanks
Welcome to the forums. Its hard to state whether it works on SQL 7, but you should be able to get alert it is happens when the alert is configured. Also as per the error message you have defined ensure the proper sizes are allocated to MSDB & TEMPDB, otherwise this could bring down the server permanently.
