Storage Consideration for SQL Server 2005 DW environment

Storage design is a key component of data warehouse/BI environment. Optimum storage design provides significant performance. SQL Server performance depends heavily on the I/O subsystem. Unless your database fits into physical memory, SQL Server constantly brings database pages in and out of the buffer pool. This generates substantial I/O traffic. Similarly, the log records need…

2

Data Protection Manager – an ultimate solution for protecting SQL Server data

I learned about new tool from Microsoft System Center family called Data Protection Manager 2007.   Here is some details on how it works and how can it save big bucks when comparing with other backup compression tool in market such as LiteSpeed. Below is its overall architecture:   How does SQL Server protection with DPM…

1

A Great SQL Resource – SQLCommunity.com

I came across www.SQLCommunity.com – a great resource for SQL Server.    It has tones of information including Scripts and Tools, Tips, Tricks and Techniques, lots of info on SQL Events, etc.  This site is run by Saleem Hakani – a Microsoft Database Engineer.  I know Saleem very well, he is very passionate about bringing SQL…

0