SQL Feeds - All your SQL feeds in one place.

Saturday, March 14, 2009

Database Maintenance Best Practices Part III - Transaction Log Maintenance

by kimberly.nospam@nospam.sqlskills.com (kltripp) via Kimberly L. Tripp on 3/14/2009 2:23:00 PM

This is a tough topic. It's a big topic and more than any other - I think there are a lot of misunderstandings about what the log is for, why it's so critical and ESPECIALLY when/why it gets extrememly large. Simply put, it gets large when it's not managed correctly. OK, there are times when it can become large - even if it is well managed. But, more often than not, when a transaction log is wildly out of control (orders of magnitude larger than the data itself) it indicates a manag ...

[ read more ]

Analysis Services Partition Size

by richtk via Microsoft SQL Server Development Customer Advisory Team on 3/14/2009 1:41:00 AM

Thomas and I updated the SQL Server 2008  Analysis Services Performance Guide principally to address features available in the latest release. But there was one important change related to partition size driven by changes in hardware. The earlier version of the performance guide for SQL Server 2005 Analysis Services Performance Guide stated this:   “In general, the number of records per partition should not exceed 20 million. In addition, the size of a partition should not exceed ...

[ read more ]

Legal Note

The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.

Advertise with us