Browse by Tags

• benchmarking
• best practice
• blogs
• clustering
• configuration
• contention
• environment
• guid
• i/o
• indexes
• maintenance plan
• memory
• monitoring
• overhead
• performance
• performance monitoring
• rebuild
• resources
• san
• uniquire
• view

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 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

Performance consideration or overhead having primary key with 3 GUID (Clustered Index)
25 September 07 02:17 PM | SQL Master | 2 Comments   

During a database design there has been an interesting discussion that will there be any performance addition in adding a second non-clustered index on a Globally Unique ID ( GUID ) column that has already a unique clustered index. IF needed you need Read More...

Filed under: overhead, uniquire, guid, performance, sql server, indexes, clustered, view

Does rebuilding a clustered index rebuild nonclustered indexes?
25 June 07 01:45 PM | SQL Master | 1 Comments   

Does rebuilding a clustered index rebuild nonclustered indexes? I have discussed this question with one of SQL Server MVP recently, eventually both were correct to the point. Lately I have found KhenBlog on the subject, interesting. Read More...

Filed under: performance, sql server, indexes, clustered, rebuild