Browse by Tags

• activity
• best practice
• cache
• clustered
• configuration
• contention
• cpu
• databases
• disks
• dmv
• maintenance plan
• memory
• microsoft
• monitoring
• object
• performance
• performance monitoring
• resources
• security
• statistics
• storage
• throughput
• tsql
• tuning
• type
• vendor
• wait

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

How to monitor transaction activity between the databases?
10 January 08 03:23 AM | SQL Master | 2 Comments   

Recently I have been through interesting forum post on SQL Server performance website that a user asking how to monitor transaction activity between the databases without using a third party tool. Until SQL 2000 version it is not that easy to get more Read More...

Filed under: sql server, dmv, databases, tsql, statistics, i/o, activity

Determining the required capacity of an I/O subsystem before deploying the database
17 September 07 06:49 AM | SQL Master | 4 Comments   

It is a good practice to determine the required capacity for a database application before it is deployed on the Production environment. As it speaks the I/O system is "most" important to the performance of SQL Server, in the event of any performance Read More...

Filed under: performance, sql server, microsoft, security, storage, i/o, vendor, throughput

ASYNC_NETWORK_IO: query is slow
29 August 07 03:00 AM | SQL Master | 2 Comments   

When you run normal SELECT statement from the Activity Monitor, the session has a status of "suspended", a command of "SELECT" and a wait type of "ASYNC_NETWORK_IO". What do you expect to the see the results and within the column status, we will see quite Read More...

Filed under: tuning, performance, sql server, wait, object, i/o, disks, type

List of CPU based DMVs in SQL Server 2005 - best used for hardware analysis
05 August 07 12:32 PM | SQL Master | 5 Comments   

Dynamic Management Views (DMV) are very useful to get server state information to monitor the status, but not always you have to still continue in monitoring using SYSMON & PROFILER that are available by default with SQL installation. The engine within Read More...

Filed under: performance, sql server, cache, dmv, cpu, i/o