Ramblings of a DBA

Tara Kizer
posts - 166, comments - 837, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

September 2008 Blog Posts

File Growth Settings for SQL Server Databases

Autogrowth is enabled by default for the SQL Server database files.  The default setting of 10% for file growth on the database files can often times lead to poor performance, especially if you don't properly size your files for the near future.  An example of when you'll see poor performance is when you have a database that is 500GB in size.  When it runs out of free space, it'll autogrow by 50GB.  Depending upon your disk performance, this could take a bit of time to allocate the space which could impact your end-users.  To minimize the impact, change the file...

posted @ Thursday, September 11, 2008 12:31 PM | Feedback (2) |

Defragmenting Indexes in SQL Server 2005

EDIT: There is a new version of this stored procedure. I've made a couple of changes to my defragment indexes stored procedure, isp_ALTER_INDEX, based upon feedback I've received from my blog readers.  For those unfamiliar with this object, it defragments indexes in SQL Server 2005 using the ALTER INDEX command.  Check the comment header block for its documentation. Here are the changes: Added support for database and object names with special characters. Added support for indexes with the ALLOW_PAGE_LOCKS option enabled.  Online reindexing is not available for indexes with this option enabled. ...

posted @ Wednesday, September 03, 2008 9:56 PM | Feedback (14) | Filed Under [ SQL Server - Database Administration ]

Powered by:
Powered By Subtext Powered By ASP.NET