Browse by Tags

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 configuration disk layout - best practices from field

Published 3 April 8 3:17 AM | SSQA.net

Configuration of server such as disk and memory is an important factor for SQL Server Performance, there is all about questions within newsgroups and forums that how do I setup the disk layout for a SQL Server database (say, 2005 version). Not only this...

Filed under: sql server, performance, data, log, disk, best practices, tempdb, monitoring, configuration, layout

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

Warning: Autogrow of file 'DB File Name' in database 'DB Name' took <number> milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.

Published 21 February 8 6:22 AM | SSQA.net

The message on subject is self-explanatory where your disk subsystem is referring to SQL Server that it is unable to cope up the demand. Having AUTOGROW option enabled on a SQL Server database is a common setup that allows SQL Server automatically expands...

Filed under: sql server, performance, databases, dba, disk space, error log, monitoring, configuration, alter database, auto grow