Browse by Tags

SQL Server 2005 Database Mirroring choosing optimum value for auto-failover timeout?

Published 12 May 8 4:25 AM | SSQA.net

Choosing a better plan to reduce outage to your database application is a beginner to provide High Availability to your application, irrespective to database or server. You may be aware that SQL Server 2005 version provides the database mirroring which...

Filed under: sql server, databases, best practices, database mirroring, 2005, principal, witness, mirror, timeout

SQL Server Upgrade Advisor Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Published 13 February 8 5:2 AM | SSQA.net

One of the client referred about the error during the execution of Upgrade Advisor: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Initial thoughts lead to checking the SQL Server timeout...

Filed under: sql server, tools, upgrade, replication, error, error log, timeout, servers

SQL Server 2005 methods to find table INDEX or Statistics age for better performance

Published 9 January 8 2:55 AM | SSQA.net

Recently we have had problems on one of the database that is used on 24/7 basis where a ETL process to import and export millions of rows on few tables has been taking longer time to finish. Further the SELECT queires on reports are timed-out and smaller...

Filed under: sql server, performance, query, index, process, agent, statistics, timeout, statiscs age

FIX: You receive a time-out error message when you try to send a message to the target service of a Service Broker application that you create in SQL Server 2005

Published 15 October 7 2:23 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, error, kba, service broker, timeout, target service

FIX: Error message when you run a stored procedure that references tables after you upgrade a database from SQL Server 2000 to SQL Server 2005: "A time-out occurred while waiting for buffer latch"

Published 19 August 7 4:44 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Error message when you run a stored procedure...

Filed under: sql server, database, upgrade, kba, timeout