There are a number of uses for the DBCC SQLPERF command. I touched upon one of them in my last post on how you can use the command to obtain information about transaction log growth. This handy little DBCC command has been around for a while now. So lets look at the others ways you use it.... Viewing wait statistics data Clearing wait statistics data Clearing … [Read more...] about Using DBCC SQLPERF
dbcc
Monitoring SQL Server Transaction Log Growth Using DBCC SQLPERF(logspace)
For this article, I am using DBCC SQLPERF(logspace) to get size information about the transaction logs. I hope you will find this post useful in helping to monitor the growth of your transaction logs. The idea here is to capture and store the growth information at set intervals. This can provide a way to report on how much the logs are growing by and when. Reports are then … [Read more...] about Monitoring SQL Server Transaction Log Growth Using DBCC SQLPERF(logspace)
Using DBCC FREEPROCCACHE to Clear SQL Server Procedure Cache
It is possible to clear out the entire SQL Server procedure cache using DBCC FREEPROCCACHE The procedure cache is where SQL Server will cache execution plans after they have been compiled. The benefit of this caching is that there is no need for the execution plans to be compiled at run time. This compiling operation typically consumes resource and slows down the execution … [Read more...] about Using DBCC FREEPROCCACHE to Clear SQL Server Procedure Cache
Reset Table Identity Value Using DBCC CHECKIDENT RESEED
DBCC CHECKINDENT RESEED can be used to reset a tables identity value on a column. On the official Microsoft page about it, it reads "Checks the current identity value for the specified table in SQL Server 2016 and, if it is needed, changes the identity value. You can also use DBCC CHECKIDENT to manually set a new current identity value for the identity column." This … [Read more...] about Reset Table Identity Value Using DBCC CHECKIDENT RESEED
Using DBCC INPUTBUFFER for SQL Server troubleshooting
In my last post on sp_who2 I demonstrated how this handy utility can help you in your SQL Server troubleshooting efforts. Continuing on from this, I am going to cover DBCC INPUTBUFFER What is DBCC INPUTBUFFER ? It is a command used to identify the last statement executed by a particular SPID. You would typically use this after running sp_who2. The great thing about … [Read more...] about Using DBCC INPUTBUFFER for SQL Server troubleshooting