Browse by Tags

• 2005
• alter database
• analysis
• auto grow
• baseline
• benchmarking
• best practice
• cache
• clustered
• contention
• databases
• dba
• deployment
• disk
• disk space
• downloads
• error log
• hardware
• i/o
• IO
• iometer
• latches
• latching
• maintenance plan
• memory
• monitoring
• performance
• performance monitoring
• raid
• resources
• san
• sql server
• sqlio
• system
• tools
• troubleshoot

SQL Server latch waits - index contention & performance issues how DMVs can help you to get information?
17 April 08 03:06 AM | SQL Master | 2 Comments   

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 Read More...

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

SQL Server 2005 Scalability and Performance - recommended limit on number of instances on a clustered environment?
04 April 08 02:48 AM | SQL Master | 3 Comments   

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, Read More...

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

SQL Server Memory - what's your method on Configuration and Troubleshooting Issues
01 April 08 02:49 AM | SQL Master | 5 Comments   

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 Read More...

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

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.
21 February 08 05:22 AM | SQL Master | 2 Comments   

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 Read More...

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

Best way to deploy SQL Server 2005 with SAN
28 January 08 01:01 AM | SQL Master | 6 Comments   

If it is a first time you are deploying the SQL Server 2005 on a SAN, then there are few things you need to be considered that will be raised by installations that are either deploying SQL Server for the first time or are upgrading to SAN from direct Read More...

Filed under: performance, sql server, sqlio, raid, hardware, best practice, downloads, benchmarking, san, iometer, configuration, tools, 2005, deployment