Browse by Tags

• 2005
• alter database
• auto grow
• baseline
• benchmarking
• best practice
• cache
• conference
• databases
• dba
• deployment
• disk space
• downloads
• error log
• hardware
• iometer
• management data warehouse
• mdw
• memory
• monitoring
• new feature
• performance monitoring
• raid
• san
• sql server
• sqlio
• system
• tools
• troubleshoot
• version

Performance Monitoring using SQL Server Management Studio - Power of Management Data Warehouse
16 September 08 01:01 AM | SQL Master | 2 Comments   

How many tools do you (need/use0 to monitor the performance of your SQL Server instance(s)? Well, I'm not asking any count on the x number of tools you require to monitor the SQL Server instances within your environment, and Performance Tuning using Management Read More...

Filed under: performance, sql server, performance monitoring, configuration, conference, new feature, version, management data warehouse, mdw

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