This link has been bookmarked by 4 people . It was first bookmarked on 27 Sep 2007, by Just TheDBA.
-
22 Sep 08
-
07 Jul 08
-
SQL 2000 Support Ends
Mainstream Support for SQL 2000 is coming to an end.
-
Encryption
There are several encryption options; the first is called Transparent Data Encryption. In SQL Server 2008, the entire database can be encrypted by the SQL Engine.
-
Auditing
In addition to the standard auditing of logon / logoffs and permission changes, SQL Server 2008 allows for monitoring of data changes or access.
-
Data Compression
Usually, data compression is associated with general hard disk savings, and with smaller physical files, backup times are reduced. While this holds true for SQL Server Data Compression, the main goal is Fact Table size reduction.
-
Resource Governor
New in SQL Server 2008 is the Resource Governor. The Governor is used to restrict users or groups of users from consuming high levels of resources. Items that can be monitored include CPU bandwidth, timeout waits, execution times, blocking times, and idle times.
-
- SQL Server dashboard
- Performance monitoring
- Current and historical data analysis
- Suggestions for potential performance tuning
- Data collection sets-based reports
- MDW-based reports
Performance Data
The amount of Performance Counters in SQL Server 2008 has been expanded compared to earlier versions. IO and memory usage counters are just a couple of the items that can be collected to monitor performance. The data collected by the counters is stored in a centralized data warehouse. Microsoft states that running the default set of performance related monitors will consume less than 5% of CPU and memory resources.
There is also now a Performance Dashboard tool that can read saved performance data. In addition, historical and baseline comparisons can be made and used to create action triggers. For example, if memory use exceeds a threshold for more than five minutes, a more detailed data collection can be automatically triggered.
New in SQL Server 2008 is the Performance Studio. The Studio is a collection of performance tools. Together they can be used for monitoring, troubleshooting, tuning and reporting. The Data Collector component of the studio is configurable and low overhead. It supports several colleting methods including TSQL queries, SQL Trace, and Perfmon Counters. Data can also be collected programmatically. Once data is collected, there are drill-down and aggregate reporting options. Microsoft lists these six client side features of the Performance Studio:
-
-
27 Sep 07
-
10 Sep 07
Would you like to comment?
Join Diigo for a free account, or sign in if you are already a member.