SQL Server provides fewer tools to monitor the transaction log, compared to the tools to monitor the rest of the database.
You have already learned how to monitor the transaction log size with SQL-EM. To monitor the log size with SQL, you use the dbcc sqlperf command. The syntax is as follows:
When running dbcc sqlperf, SQL Server generates the following output:
When reviewing this output, look at the log space percentage. If the log space used is high, you should either dump your transaction log or
make sure that the logs can automatically grow. In most cases, if you have a properly sized transaction log, you will want to dump the log. In the next lesson, you will learn how to maintain a tables statistics.
Click the Exercise link below to test your knowledge of the dbcc commands presented in this module so far. dbcc-commands