Browse by Tags

• 2005
• 3gb
• applications
• awe
• backups
• baseline
• blocking
• blog
• blogs
• clustered
• clustering
• configuration
• dashboard
• databases
• deployment
• disks
• downloads
• dynamic
• environment
• FAQ
• hardware
• iometer
• maintenance plan
• memory
• microsoft
• monitoring
• msdn
• pae
• performance
• performance monitoring
• raid
• san
• scsi
• security
• settings
• sql server
• sqlio
• table variable
• tablesample
• temp tables
• tempdb
• tools

SQL Server 2005: Clustering FAQ is Active/Active a load balancing solution?
29 February 08 03:04 AM | SQL Master | 4 Comments   

Another FAQ within newsgroups & forums that will SQL Server Clustering supports load balancing? It is quite common for a newbie to say and look at Clustering configuration such as Active-Active where you have n+1 nodes as a serving instances, the Read More...

Filed under: performance, sql server, clustered, best practice, clustering, blogs, monitoring, environment, benchmarking, san

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

Is RAID5 better for performance when SQL Server Clustering and SAN is involved?
22 January 08 11:28 PM | SQL Master | 8 Comments   

One of the recent usergroup meeting brought an interesting question that "what type of hardware I need for a RAID-5 Shared Array for SQL Server Cluster"? By default RAID5 hardware controller is best to hold as not to go with software RAID5 as it will Read More...

Filed under: performance, sql server, raid, hardware, disks, best practice, monitoring, benchmarking, san, scsi

SQL server Temporary Tables, Table Variables and Recompiles - interesting scenario
17 January 08 01:23 AM | SQL Master | 2 Comments   

Usage of Temporary tables or variables is a common scenario in SQL Server world, since SQL Server 2005 usage of TEMPDB references to the blog posts here: http://sqlserver-qa.net/blogs/tools/archive/2007/04/05/sql-server-index-optimization-best-practices.aspx Read More...

Filed under: performance, sql server, blocking, msdn, tablesample, tempdb, best practice, FAQ, monitoring, maintenance plan, benchmarking, table variable, temp tables

SQL Server 2005 memory configuration gotchas
28 December 07 03:44 AM | SQL Master | 5 Comments   

This may be last post in Performance Tuning & Security blog section here for this year!! Most of this year in the forums & newsgroups I have seen a common question asking about memory configuration within SQL Server 2005. As you may be aware that Read More...

Filed under: performance, sql server, security, memory, pae, awe, best practice, 3gb, performance monitoring, benchmarking, dynamic, settings, applications

SQL Server performance monitoring requirement and specifications, heard about baseline and benchmarking?
19 December 07 05:06 AM | SQL Master | 3 Comments   

How do you define the terms "Performance Monitoring"? What is your baseline & benchmarks? Have you ever used PERFMON (SYSMON) & PROFILER for serious performance issues within your SQL Server environment? The answer may be not 'yes' for all the Read More...

Filed under: performance, sql server, microsoft, security, blog, databases, dashboard, best practice, backups, monitoring, baseline, performance monitoring, downloads, environment, benchmarking