Browse by Tags

All Tags » tuning (RSS)
You can pre-order the Kalen Delaney SQL Server Internals Course on DVD
Published 30 January 8 8:52 AM | SSQA.net
Great news to all SQL Server users! The DVD - Kalen Delaney SQL Server Internals course (part1) is almost ready and you can pre-order a copy right now! This is our first in what we hope to be will be an entire series of outstanding SQL Server training...
Filed under: , , , , , , , ,
We wish you Happy Holidays - Merry Christmas and New Year !!!
Published 21 December 7 6:29 AM | SSQA.net
Merry Christmas .... HAPPY NEW YEAR... whatever makes your wish come true! Wish you HAPPY HOLIDAYS and be safe/have fun during this season............ Thanks for all the support and registering here.... hope you find this site useful for your tasks.....
Filed under: , , , ,
If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?
Published 15 November 7 9:41 AM | SSQA.net
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...
Filed under: , , , , , , , , , , ,
What should I choose Load Balancing or Data Partitioning?
Published 12 September 7 5:42 AM | SSQA.net
One of our client had such requirement to cater a load balancing for their application and needed to upgrade to higher versions of SQL Server & Operating systems. The current setup at their end is a SQL Server 2000 Active/Passive Cluster and the transactions...
Filed under: , , , , , ,
Another Best Practices article: Identifying and Resolving MDX Query Performance Bottlenecks
Published 5 September 7 4:34 AM | SSQA.net
Best Practices are good enough to follow, but simply do not read and digest. Try to implement them within your environment to keep up the performance. Similary there are many things involved within the SQL Server 2005 Analysis Services such as MDX queries...
Filed under: , , , , , , ,
TSQL to obtain a list of current execution of Parallel Plans (MAXDOP)
Published 4 September 7 9:32 AM | SSQA.net
PARALLELISM is a close friend of DBA where you get to see it as a common occurence in the multi-processor server environment and during such performance issues you can also investigate whether a parallel plan is in use. For instance If a particular query...
Filed under: , , , , , , , , ,
ASYNC_NETWORK_IO: query is slow
Published 29 August 7 5:0 AM | SSQA.net
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...
Filed under: , , , , , , ,
Performance Tuning - will I loss the indexing when using derived table?
Published 21 August 7 3:19 AM | SSQA.net
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...
Filed under: , , , , , ,
How to Analyze the PERFMON (SYSMON) data?
Published 20 August 7 1:26 PM | SSQA.net
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...
Filed under: , , , , , , ,
Dig further for a process (SPID) using Query Analyzer (SQL 2000 version specific) not DBCC INPUTBUFFER though.
Published 20 August 7 6:53 AM | SSQA.net
Based on this Troubleshoot a process (SPID) using tools & TSQL queries blog post I have been asked to provide same information within SQL Server 2000 version, as that talks about SQL 2005 version specific. Within SQL 2000 to troubleshoot further about...
Filed under: , , , , , ,
SQL Server Licensing for a quad CPU server, a mystery?
Published 16 August 7 10:9 AM | SSQA.net
Microsoft Licensing methods for SQL Server is always a mystery! Though visiting HOWTOBUY says what type of license choose but nothing much to understand. Scalable link explains bit more than that page. Still I have to search for a quest on how many processor...
Filed under: , , , , ,
Dust out few tasks to gain transactional replication performance in SQL 2005
Published 16 August 7 4:20 AM | SSQA.net
Coming to the basics of Transactional Replication, that starts with a simple snapshot of publication database data. Similar to the name the process is carried upon the fashion of transactions and subsequent data changes and schema modifications made at...
Filed under: , , , , , , , ,
Make use of tools and utilities that are available in SQL Server - performance & tuning
Published 8 July 7 7:19 AM | SSQA.net
There are various tools available within SQL Server installation such as SQLDIag, SQLDumper, PSSDiag (to be downloaded as a seperate tool), SYSMON(PERFMON) and Profiler etc. Among these SqlDiag and Sqldumper are most important to get more information...
Filed under: , , , , , , , ,
SQL Server 2005- Is it possible to schedule Data Tuning Advisor?
Published 15 June 7 8:32 AM | SSQA.net
I came across interesting post in SSP looking for a way of automating the Database Tuning Advisor tool of SQL Server 2005 with the help of SQLServer Agent. As the originator looking to schedule it on a regular basis to scan a trace (Profiler) file and...
Filed under: , , , , ,
SQL Server 2005 Performance tuning tools for PASS members
Published 4 May 7 6:45 AM | SqlServer-QA.net (SSQA)
SQL Server 2005 Performance Tuning Tools for PASS Members Whether you're thinking about migrating to SQL Server 2005 or you've already made the leap, this collection of expert tips from SearchSQLServer.com will guide you toward optimizing Microsoft's...
Filed under: , , , ,