Tag Info

New answers tagged


I would suggest you run a profiler on the database with tsql replay and analyse the results. Another idea is to take a look at your plancache and check if there are query plans which will produce a huge overhead. Another idea is to run perfmon on the sql server and run a profiler too. That way you might seen some big write accesses which you correlate to ...


Try running     select * from sys.database_files by using your database and then master db. You will see the log and database files of your db only when you're using your db. So -        declare @fileId as int = (select file_id from sys.database_files where name = 'XY')       DBCC SHRINKFILE (@fileId, 0, TRUNCATEONLY) and     DBCC SHRINKFILE ...

Top 50 recent answers are included