Browse by Tags

• analysis
• best practice
• databases
• dbcc
• disks
• i/o
• indexed views
• joins
• management
• max worker threads
• microsoft
• object
• perfmon
• performance
• query
• resources
• security
• server
• sqlperf
• ssms
• stored procedure
• sysmon
• system
• testing
• tsql
• type
• upgrade
• wait

If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?
15 November 07 08:41 AM | SQL Master | 2 Comments   

Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must Read More...

Filed under: tuning, performance, sql server, microsoft, server, dbcc, testing, best practice, resources, max worker threads, sqlperf, system

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

Performance Tuning - will I loss the indexing when using derived table?
21 August 07 01:19 AM | SQL Master | 2 Comments   

This was the question asked by a Developer when we are investigating a performance loss issues on a database. To the point a derived table means a virtual table that's calculated on the fly from a select statement. By default using derived tables can Read More...

Filed under: indexed views, tuning, performance, sql server, query, stored procedure, joins

How to Analyze the PERFMON (SYSMON) data?
20 August 07 11:26 AM | SQL Master | 2 Comments   

As you may aware the PERFMON (SYSMON) utility provides much information to analyze on the systems resource usage, I support and suggest to make use of this tool as much as you can with a default templates within our environment. You may be aware the data Read More...

Filed under: tuning, performance, sql server, perfmon, databases, sysmon, tsql, analysis

Database Tuning Advisor - how far it can help?
25 April 07 12:06 PM | SQL Master | 0 Comments   

SQL Server 2000 includes Index Tuning Wizard (launch from Enterprise Manager | Tools | Wizards... | Management) that allows selecting and creating an optimal set of indexes and statistics for a SQL Server 2000 database. This wizard is now being replaced Read More...

Filed under: tuning, sql server, security, management

Things to take care for performance tuning after upgrading from SQL 2000 to 2005?
24 April 07 12:37 PM | SQL Master | 0 Comments   

The first thing that needs to be touched on is whether the upgrade is going to be performed by taking an existing SQL Server installation and upgrading it or by installing SQL Server 2005 on a new machine and migrating databases to it. Also use the Upgrade Read More...

Filed under: ssms, tuning, performance, upgrade, sql server