SqlServer-QA.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 videos by the top experts in the world at prices that everyone can afford. Kalen ...

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 test the implications and usage in hiking such a value that will affect the whole server ...

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 per minute were good enough with this setup, due to the recent campaign of the ...

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, data mining etc. For any sort of performance analysis exercise you must ...

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 is slow when it is using a parallel plan, you can try forcing a non-parallel plan by ...

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 a few requests which are in the status ‘suspended’ and some others as ‘running’. ...

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 be tremendously useful in certain situations. In any case if you have 2 queries in hand say one ...

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 is saved as a file with .BLG extension which can be opened again using this SYSMON tool. I ...

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 a SPID you can use: DECLARE @Handle binary(20)SELECT @Handle = sql_handle FROM ...

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 licenses should we purchase for a 2 QUAD CPU server. Eventually ...