Browse by Tags

A fatal error occurred while reading the input stream from the network. The session will be terminated. Error: 4014, Severity: 20, State: 2

Published 1 October 7 4:40 AM | SSQA.net

This is a typical error you would get when a SSIS package is executed that involves remote server connectivity. Basically on the error note it will clearly identified as a network related issue. Similar issue happened at our end whereas the SSIS package...

Filed under: sql server, performance, ssis, trace, update, error, kba, installation, instances, 4014, netmon

Table fragmentation, Index contention and locking issues to resolve

Published 31 July 7 9:31 AM | SSQA.net

Yet another important factors that every DBA needs to concerned about table & index fragmentation within their SQL Server environment. Refer to the a rticle about DetectTableFragmentation in both 2000 and 2005 version. Fragmentation occurs due to...

Filed under: sql server, profiler, performance, blocking, trace, process, table, locking, loss, fragmentation

Having 'black-box' recorder for SQL Server!

Published 2 July 7 3:34 AM | SSQA.net

Say you have a serious performance problem and few times you will have assertion issue with a dump files creation, in real world say this can be matched to a airplane crash. Where you will know the sequence of events from Black-box records in the flight...

Filed under: sql server, profiler, performance, msdn, blogs, trace, black-box

Database consistency checks and transaction log is filing up, help?

Published 9 May 7 6:40 AM | SqlServer-QA.net (SSQA)

Yet anothe forums related question I would like to blog, as I have seen in my experience on newsgroups. There will be always a question asking about why Transaction log is filling up and blocking is ocurred when a DBREINDEX & CHECKDB processes are...

Filed under: sql server, performance, transaction log, dbcc, trace, search, concurrency, dba