Browse by Tags

All Tags » sql server » best practice » monitoring (RSS)
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 Memory - what's your method on Configuration and Troubleshooting Issues
Published 1 April 8 4:49 AM | SSQA.net
Memory - an important aspect of system performance within a RDBMS platform, not specific to a database product or application. Coming to Microsoft related products such as Windows Server and SQL Server so on, various resources available on web such as...
Filed under: , , , , , , , , , , , ,
What's your practice on Disk Defragmentation methods - specific to data file and indexes drives?
Published 26 March 8 3:1 AM | SSQA.net
Fragmentation is dearest friend of database when you need to deal with Performance, so by using the DBCC statements and other methods here you can deal the database level fragmentation, what about the physical level fragmentation? So what is the best...
Filed under: , , , , , , , , , , ,
SQL Server 2005: Clustering FAQ is Active/Active a load balancing solution?
Published 29 February 8 4:4 AM | SSQA.net
Another FAQ within newsgroups & forums that will SQL Server Clustering supports load balancing? It is quite common for a newbie to say and look at Clustering configuration such as Active-Active where you have n+1 nodes as a serving instances, the...
Filed under: , , , , , , , , ,
SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!
Published 25 January 8 3:41 AM | SSQA.net
Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation...
Filed under: , , , , , , , , , , , , ,
Is RAID5 better for performance when SQL Server Clustering and SAN is involved?
Published 23 January 8 12:28 AM | SSQA.net
One of the recent usergroup meeting brought an interesting question that "what type of hardware I need for a RAID-5 Shared Array for SQL Server Cluster"? By default RAID5 hardware controller is best to hold as not to go with software RAID5 as...
Filed under: , , , , , , , ,
SQL server Temporary Tables, Table Variables and Recompiles - interesting scenario
Published 17 January 8 2:23 AM | SSQA.net
Usage of Temporary tables or variables is a common scenario in SQL Server world, since SQL Server 2005 usage of TEMPDB references to the blog posts here: http://sqlserver-qa.net/blogs/tools/archive/2007/04/05/sql-server-index-optimization-best-practices...
Filed under: , , , , , , , , , , , ,
SQL Server 2005: Deny Server-Level Dynamic Management Views to public group
Published 21 December 7 7:47 AM | SSQA.net
As you are aware DMV - Dynamic management views are very good to provide server-level information and some of them with detailed information on the execution environment of the database engine. Just to introduce about DMVs, there are two types of dynamic...
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: , , , , , , , , , , , , , ,