Earlier I mentioned that you might want to change the number of logs that SQL Server keeps. If you right-click the SQL Server Logs object and select the Configure. item from the menu that appears, you’ll be able to set the number of logs you want to keep. The SQL Server Agent log is located in a different place in SQL Server 2000.
Once the stored procedure is in place on all production servers, I created a SQL Server Agent Job that executes this stored procedure and scheduled it to execute at a 5 minute interval. My next step was to configure my alerting server to send the email alerts.
The world's most popular open source database MySQL.com; Downloads; Documentation; Developer Zone; Developer Zone Downloads MySQL.com.
The latest SQL Server articles from SQLServerCentral. Frequently I have been called upon to write SQL Stored Procedures (SP) that will be run by SQL Agent on a scheduled basis.
The LOG() function returns the natural logarithm of a specified number, or the logarithm of the number to the specified base. From SQL Server 2012, you can also change the base of the logarithm to another value by using the optional base parameter. Note: Also look at the EXP() function. Syntax.
SQL Server Failover Clustered Instances (FCI) and Availability Groups (AG) depend a lot on Windows Server Failover Clustering (WSFC). Understanding how the underlying WSFC platform works can help us maintain availability of our databases As I was driving out of my driveway, I noticed something that is considered to be every car owner's worst nightmare: the check engine light.
By default, SQL Server does not register much information about deadlocks. There is a trace flag 1222. If you set it on, deadlock information will be logged in SQL Server Error Log. The following statement enables 1222 flag globally for the whole instance - if a deadlock occurs in ANY of the databases on an instance, it will be registered.
When a SQL Server session waits on the WRITELOG wait type, it is waiting to write the contents of the log cache to disk where the transaction log is stored. To explain the process in more detail, assume a session starts a transaction that will perform several INSERT statements.