Browse by Tags

• 2005
• 3gb
• active/active
• active/passive
• applications
• awe
• backups
• baseline
• benchmarking
• best practice
• best practices
• blog
• clustering
• conference
• configuration
• dashboard
• databases
• dba
• dmv
• downloads
• dynamic
• engine
• environment
• hints
• index plan
• indexes
• knowledge
• maintenance plan
• management data warehouse
• mdw
• measures
• memory
• microsoft
• monitoring
• new feature
• optimization
• pae
• parallel execution
• partition
• perfmon
• pssdiag
• query
• resource governor
• rml
• scalability
• security
• settings
• sql server
• sqlcat
• sqldiag
• sqlnexus
• sys.dm_db_index_physical_stats
• sysmon
• tempdb
• utilities
• version

SQL Server - PERFMON counters and Resource Governor - what you can do in a performance issue situation?
17 November 08 12:41 AM | SQL Master | 2 Comments   

PERFMON and Resource Governor - two great tools in hand for a DBA to monitor/resolve the performance problems, agreee! Back in olden days you may remember about SQLDiag and PSSDiag, the utility used as a general purpose diagnostics collection utility Read More...

Filed under: performance, sql server, dmv, perfmon, dba, sysmon, performance monitoring, new feature, resource governor

Quick tips & tricks on fine tuning performance problem on a SQL Server instance.
06 October 08 02:51 AM | SQL Master | 2 Comments   

Few months ago I had an excellent opportunity to learn and share the knowledge within SQL Server performance tuning, Tech-Ed Online talks [remember Tech-ed Online Panel: Leveraging ... ]. Same in the series Amit Bansal, SQL Server MVP from India and myself Read More...

Filed under: performance, sql server, query, optimization, hints, performance monitoring, best practices, knowledge, engine

Performance Monitoring using SQL Server Management Studio - Power of Management Data Warehouse
16 September 08 01:01 AM | SQL Master | 2 Comments   

How many tools do you (need/use0 to monitor the performance of your SQL Server instance(s)? Well, I'm not asking any count on the x number of tools you require to monitor the SQL Server instances within your environment, and Performance Tuning using Management Read More...

Filed under: mdw, performance, sql server, performance monitoring, configuration, conference, new feature, version, management data warehouse

SQL Server - Precision Performance techniques using RML Utilities
09 June 08 05:50 AM | SQL Master | 4 Comments   

As a DBA, you probably often find yourself striving or struggling to improve the performance of SQL Server instance queries (might be smaller or complex ones). By default in order to get further analysis on the system's performance you need to perform Read More...

Filed under: performance, sql server, dmv, sqldiag, performance monitoring, pssdiag, rml, sqlnexus, utilities, sqlcat

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 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 DMV - how it can help to consider whether index is useful or not?
04 February 08 07:06 AM | SQL Master | 4 Comments   

When it comes to performance, for a DBA indexes are the first one to come to mind in order to fine tune the tasks on the database. In this series we have already covered this huge topic of indexing and how best you can make use of Dynamic Management Views Read More...

Filed under: performance, sql server, dmv, indexes, dba, performance monitoring, index plan

SQL Server Query Performance - think about page split and fragmentation, measures to reduce the behaviour and best use of dm_db_index_physical_stats DMV
14 January 08 01:22 AM | SQL Master | 2 Comments   

It is an universal truth in the database field that due to the fragmentation and page split the performance will be affected even for a simple [ SELECT <ColumnName> from.... ] type of query. So what you need to check or take action in terms of DBA Read More...

Filed under: performance, sql server, dmv, indexes, dba, best practice, maintenance plan, performance monitoring, sys.dm_db_index_physical_stats, measures

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