SqlServer-QA.net

You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based RAID. This could be due to one of the reasons such as starting location of partition is ...

As blogged here before Virtual Labs are very handy for the new users and existing professionals to test out new features without disturbing their own platform. In this scenario Microsoft events are helping the users by providing access to their virtual platform for BI & Relational Databases that are built in latest operating system with new ...

How many SQL Server licenses you need to fix the number of CPUs on the server? The answer it depends on the number! Well having hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2 logical CPUs) and dual-core technology (i.e. a single CPU socket that has more than 1 core appearing as multiple logical CPUs) is a ...

Recently I have to search for the information on the total size of free physical memory on the SQL Server which is causing lots of performance issues, when reported to CSS they have supplied the following TSQL to get more information in this regard: With VASummary(Size,Reserved,Free) AS (SELECT   Size = VaDump.Size,   Reserved = ...

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' for all the questions above, in general getting know more about performance monitoring methods is not ...

Interesting popup message on the down-right corner of my laptop when I'm performing SQL Server tasks against a 2005 version database using SQL Server Management Studio (SSMS), displays the message ''Microsoft SQL Server Management Studio is waiting for an internal operation to complete. If you regularly encounter this delay ...

As you know data compression facility is added onto the SQL Server 2008 version, though this is not a new feature and I would call it as an enhanced feature in SQL Server. This subject of data compression has already been introduced in SQL Server 2005 version which is usage of VARDECIMAL with having table-level ...

Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible). Then it comes what kind of practice you should deploy in order to obtain the ...

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 ...

It is worth mentioning the valueable query I have been through when referring to Technet Magazine, the following query has given me useful information in finding out what are my top 20 most expensive queries that are consuming most of disk I/O (read & write). November2007 magazine refers as follows: SELECT TOP 20 SUBSTRING(qt.text, ...