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

SQL Server latch waits - index contention & performance issues how DMVs can help you to get information?

Published 17 April 8 5:6 AM | SSQA.net

What kind of performance issues you see on day-to-day basis within your environment? The following elements are important factors that can add fuel to the fire (problem): Faulty hardware • Hardware that is not configured correctly • Firmware settings...

Filed under: sql server, memory, analysis, disk, IO, monitoring, configuration, iometer, contention, latches, latching

SQL Server 2005 Scalability and Performance - recommended limit on number of instances on a clustered environment?

Published 4 April 8 4:48 AM | SSQA.net

This is a very tricky question and hard to stick to 1 or few solutions as answer, it depends! Overall the say is if there isn’t any resource contention (from your pre-installation testing & analysis) and there is enough of each resource to go around...

Filed under: sql server, memory, maintenance plan, i/o, clustered, best practice, monitoring, resources, configuration, performance monitoring, contention

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

SQL Server error: messages are appearing when the working set of SQL Server 2005 process reaches 50 percent of the memory that is committed to the process.

Published 7 March 8 4:54 AM | SSQA.net

Have you seen the above message within the SQL Server error logs? If not then no need to worry and make sure to continue your performance monitoring tasks. So when to be concerned! It is evident that SQL Server 2005 component handles memory differently...

Filed under: sql server, performance, memory, dmv, windows, 2000, 2005, awe, 64 bit, monitoring, worker threads, paging out, buffers, verison