Browse by Tags

All Tags » performance monitoring (RSS)
SQL Server - Precision Performance techniques using RML Utilities
Published 9 June 8 7:50 AM | SSQA.net
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...
Filed under: , , , , , , , , ,
SQL Server Performance issues with Fragmentation and heavy usage of TEMPDB?
Published 15 May 8 3:59 AM | SSQA.net
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...
Filed under: , , , , , , ,
SQL Server 2005 Scalability and Performance - recommended limit on number of instances on a clustered environment?
Published 4 April 8 4:48 AM | SSQA.net
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...
Filed under: , , , , , , , , , ,
SQL Server Clustering - what is the difference between Active/Passive and Active/Active Clustering, which is good for better performance?
Published 18 March 8 4:20 AM | SSQA.net
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...
Filed under: , , , , , , , , , , ,
SQL Server 2005 DMV - how it can help to consider whether index is useful or not?
Published 4 February 8 8:6 AM | SSQA.net
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...
Filed under: , , , , , ,
SQL Server indexing - when to reorganize or rebuild?
Published 21 January 8 4:30 AM | SSQA.net
Re-organizing or rebuilding index would help the SQL optimizer to reduce the fragmentation for a better performance. In this case few users might have doubt that when to rebuild or reorganize (SQL Server 2005)? IN the series of Performance blog posts...
Filed under: , , , , , , , , , ,
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
Published 14 January 8 2:22 AM | SSQA.net
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...
Filed under: , , , , , , , , ,
SQL Server 2005 memory configuration gotchas
Published 28 December 7 4:44 AM | SSQA.net
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...
Filed under: , , , , , , , , , , , ,
SQL Server performance monitoring requirement and specifications, heard about baseline and benchmarking?
Published 19 December 7 6:6 AM | SSQA.net
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'...
Filed under: , , , , , , , , , , , , , ,