sql server, monitoring, databases, cache - SQLServer-QA.net

Browse by Tags

SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases? Published 25 April 8 3:30 AM | SSQA.net: In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases...

Filed under: sql server, indexes, memory, databases, cache, cpu, monitoring, operating system, huge, dbcc shrinkfile