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
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
It is a good practice to determine the required capacity for a database application before it is deployed on the Production environment. As it speaks the I/O system is "most" important to the performance of SQL Server, in the event of any performance loss or even configuring a new server for...
Since the inception of SQL Server 2005 data encryption and cryptography functionality has elevated to a new level, this wasn't the case until SQL 2000 version. The overall security improvements within SQL 2005 is mainly with 'certficate' authentication, the 3 levels are: Authentication –...
You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From the available documentation on Technet & MSDN...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
07-25-2007
Filed under: sql server, performance, management, memory, microsoft, security, server, windows, awe, /3gb, pae
You have various references available on the web about things to take care on the security management for SQL Server, in addition to the SQL Server 2005 Books Online . Features and options that are new or defaults that are changed for SQL Server 2005 are identified. So in this case you need to be aware...