Browse by Tags

• 2005
• active/active
• active/passive
• cache
• clustering
• clustersize
• cpu
• disk
• force
• guide
• hardware
• index
• lun
• microsoft
• monitoring
• optimization
• parallel execution
• performance
• performance monitoring
• scalability
• security
• technet
• testing

SQL Server Clustering - what is the difference between Active/Passive and Active/Active Clustering, which is good for better performance?
18 March 08 02:20 AM | SQL Master | 3 Comments   

First part of question is a pure newbie FAQ to know about, and the simple answer would be it is one of the Clustering type you can adopt within your SQL Server environment. To cover on newbie aspect both Active/Passive & Active/Active configuration Read More...

Filed under: performance, sql server, security, clustering, monitoring, partition, parallel execution, performance monitoring, 2005, active/active, active/passive, scalability

Considering Parallel plans and forcing plans for better performance
23 October 07 06:55 AM | SQL Master | 2 Comments   

Parameterizing T-SQL queries are a well-known task such as database programming and best practice in some tasks. It allows query plan reuse and eliminates the need of recompilation for multiple invocations of the same query that simply has different parameter Read More...

Filed under: performance, sql server, cache, optimization, cpu, index, partition, parallel execution, force, guide

NTFS Cluster size - if changing the default cluster size on the disk is a good idea or not?
16 October 07 05:18 AM | SQL Master | 2 Comments   

You might have come across on the web resources that setting the disk to a 64k cluster size (8 * 8KB pages) might achieve the performance. But have you wondered will this really boost the disk performance, see in what scenario such as lots of reads and Read More...

Filed under: testing, hardware, technet, lun, clustersize, partition, performance, sql server, microsoft, disk