Question : I used spAskBrent for troubleshooting a SQL Server 2005 performance issue. I found the problem was someone had […]
Tag: dbcc
Is there a way to suppress DBCC TRACEON/OFF messages in the Error Log?
Question : We have quite a few dataloading processes that run throughout the day all day long. These processes are […]
DBCC Shrinkfile not working on SQL 2016
Question : Executed the DBCC Shrinkfile(‘file1’,emptyfile) successfully on first file in the filegroup and removed the file that I shrank. […]
Shoudn’t DBCC SHIRNKFILE(Data_File, 0) command shrink data file to the last allocated extent?
Question : I have a datafile with the following parameters: When I execute DBCC SHRINKFILE (DBAtools_data,1), it shows the following […]
What can cause DBCC CheckDB to take longer than usual? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
How Can I Determine Object Distribution in a Multiple-File Filegroup?
Question : I am looking to eliminate an extraneous data file in a filegroup in my DB but don’t want […]
Shrink multiple database files using sp_MSForEachDB
Question : We have recently cleared out old data from our production database. The database is 3 TB with 1.4 […]
sp_blitz shows “Last good DBCC CHECKDB over 2 weeks old”
Question : When I run sp_blitz, I see -[ RECORD 5 ]————————- Priority | 1 FindingsGroup | Reliability Finding | […]
Trace flag is running, but not message when deadlock happens
Question : Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior More […]
How do I interpret the log when I run DBCC TRACEON (3502, 3504, 3605, -1)
Question : I have been using DBCC Traceon (3502, 3504, 3605, -1) because it was recommended in a blog for […]