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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
04-28-2008
Filed under: sql server, performance, microsoft, technet, i/o, article, disk, best practices, monitoring, deployment, layout
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...
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
02-20-2008
Filed under: sql server, performance, microsoft, version, article, license, 2005, cpu, monitoring, administrator, value, costing
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
02-19-2008
Filed under: sql server, performance, microsoft, version, article, license, 2005, cpu, monitoring, administrator, value, costing
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...
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
12-19-2007
Filed under: dashboard, sql server, performance, databases, microsoft, security, blog, environment, best practice, backups, monitoring, baseline, benchmarking, downloads, performance monitoring
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...
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
12-03-2007
Filed under: sql server, performance, microsoft, blogs, security, 2008, ctp, data capture, 2005, compress, data compression
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...
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
11-15-2007
Filed under: sql server, performance, microsoft, server, tuning, dbcc, system, best practice, testing, resources, sqlperf, max worker threads