Browse by Tags

• 2005
• active/active
• active/passive
• backups
• baseline
• benchmarking
• best practice
• best practices
• blog
• clustered
• clustering
• configuration
• contention
• dashboard
• databases
• dmv
• downloads
• environment
• i/o
• maintenance plan
• memory
• microsoft
• parallel execution
• partition
• performance
• resources
• scalability
• security
• sql server
• tempdb

SQL Server Performance issues with Fragmentation and heavy usage of TEMPDB?
15 May 08 01:59 AM | SQL Master | 2 Comments   

Whenever a performance issue occurs on the SQL Server database best option for diagnosing and troubleshooting common problems by using publicly available tools such as Profiler, System Monitor (Perfmon), and Dynamic Management Views (DMVs) in SQL Server Read More...

Filed under: performance, sql server, dmv, tempdb, monitoring, performance monitoring, benchmarking, best practices

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 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 monitoring, 2005, active/active, active/passive, scalability, performance, sql server, security, clustering, monitoring, partition, parallel execution

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