Browse by Tags

SQL Server configuration disk layout - best practices from field

Published 3 April 8 3:17 AM | SSQA.net

Configuration of server such as disk and memory is an important factor for SQL Server Performance, there is all about questions within newsgroups and forums that how do I setup the disk layout for a SQL Server database (say, 2005 version). Not only this...

Filed under: sql server, performance, data, log, disk, best practices, tempdb, monitoring, configuration, layout

SQL Server 2008 - enhanced feature in database mirroing "log compression"

Published 15 October 7 4:11 AM | SSQA.net

Database Mirroring - new feature from SQL Server 2005 within High Availability ranch, a software based solution for database availability. Very important for the DBAs to keep up the database recovery model to FULL at all the times to achieve the High...

Filed under: sql server, transaction log, log, features, 2008, database mirroring, compression, enhancement

FIX: Error message when you restore a transaction-log backup that is generated in SQL Server 2000 SP4 to an instance of SQL Server 2005: "Msg 3456, Level 16, State 1, Line 1. Could not redo log record"

Published 12 September 7 12:28 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you restore a transaction-log backup that is generated...

Filed under: sql server, transaction log, kba, log, backups, knowledgebase, redo

Update statistics causing negative performance

Published 17 August 7 8:11 PM | SSQA.net

Recently we have seen a negative performance for a query that is running against a 500GB size of database, where AUTO UPDATE STATISTICS is enabled and we perform weekly reindexing on this database. In addition to this I perform intermittent update statistics...

Filed under: sql server, performance, log, index, tempdb, best practice, update statistics, fragmentation

Change SQLAgent log file location after SQL Server installation

Published 11 July 7 4:17 AM | SSQA.net

Can we change the location of SQL agent error log file after the SQL Server program is installed? Yes, i n terms of configuring a specified number of SQL Server Agent error logs, this is not possible. The default number of log files for SQLAGent is 9...

Filed under: sql server, log, sqlagent, error log, location, path

Behaviour of SP_READERRORLOG in SQL 2000 and 2005

Published 22 May 7 3:3 AM | SSQA.net

You may be aware that SP_READERRORLOG can be used from a query analyzer or query editor to read the error log contents without opening the file on the disk or from Management Studio (or Enterprise Manager). I'm not sure whether you have observed that...

Filed under: sql server, microsoft, error, read, log, version, BOL, documentation