Browse by Tags

• 2005
• 3gb
• active/active
• active/passive
• applications
• awe
• backups
• baseline
• benchmarking
• best practice
• blog
• clustering
• dashboard
• databases
• downloads
• dynamic
• environment
• memory
• microsoft
• monitoring
• pae
• parallel execution
• partition
• performance
• scalability
• settings
• sql server

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

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