Browse by Tags

SQL Server Memory - what's your method on Configuration and Troubleshooting Issues

Published 1 April 8 4:49 AM | SSQA.net

Memory - an important aspect of system performance within a RDBMS platform, not specific to a database product or application. Coming to Microsoft related products such as Windows Server and SQL Server so on, various resources available on web such as...

Filed under: sql server, performance, memory, cache, disk space, troubleshoot, system, best practice, raid, hardware, monitoring, configuration, baseline

Does DBCC SHRINKFILE consumes operating system resources such as memory, CPU usage etc.?

Published 25 July 7 4:30 AM | SSQA.net

Yes it does! Until yesterday even I was under impression that it will not use or cause any issues to the server. But think about performing the SHRINK operation of transaction log & database files on regular basis, say within a scheduled job or ongoing...

Filed under: sql server, memory, database, shrink, disk space, cpu