Browse by Tags

• 2000
• 64 bit
• active/active
• active/passive
• awe
• benchmarking
• best practice
• buffers
• clustering
• configuration
• deployment
• dmv
• downloads
• hardware
• iometer
• memory
• monitoring
• paging out
• parallel execution
• partition
• performance
• performance monitoring
• raid
• san
• scalability
• security
• sqlio
• tools
• verison
• windows
• worker threads

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 error: messages are appearing when the working set of SQL Server 2005 process reaches 50 percent of the memory that is committed to the process.
07 March 08 03:54 AM | SQL Master | 2 Comments   

Have you seen the above message within the SQL Server error logs? If not then no need to worry and make sure to continue your performance monitoring tasks. So when to be concerned! It is evident that SQL Server 2005 component handles memory differently Read More...

Filed under: performance, sql server, dmv, memory, windows, awe, monitoring, worker threads, 2005, 2000, paging out, 64 bit, verison, buffers

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