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

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

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

Can we audit the activity inside the SQL Server 2008 to capture SELECTs activity? For the first time I though CDC will be useful to DBAs in auditing the activity on the database, but its not entirely.  It is equivalent to auditing functionalities and in short CDC is more poised towards the ETL for incrementatl data load and that uses an ...

Microsoft has announced the launch of Microsoft System Center Operations Manager 2007 Evaluation and if you manage systems at a medium-sized business, there is also a bevy of new resources around Microsoft Systems Center Essentials 2007 RC1. And to augment that trial experience, check out new community sites like the Systems Center Essentials ...