Browse by Tags

• 4014
• backups
• blocking
• blogs
• cpu
• databases
• error
• execution plan
• FAQ
• high cpu
• indexes
• installation
• instances
• netmon
• query
• recompile
• resources
• script
• sql server
• sqldiag
• sqldumper
• ssis
• stored procedure
• too many
• trace
• troubleshoot
• tuning
• update

Stored Procedures caught me with too many recomplies - way out to avoid it
25 October 07 01:35 AM | SQL Master | 2 Comments   

A common scenario in SQL Server environment that often application users complained about slow performance and same time you observe high CPU usage/spikes on the SQL Server instance, so better to follow the methods from HighCPU-whyitis blog and still Read More...

Filed under: performance, sql server, indexes, kba, recompile, stored procedure, high cpu, blogs, too many

A fatal error occurred while reading the input stream from the network. The session will be terminated. Error: 4014, Severity: 20, State: 2
01 October 07 02:40 AM | SQL Master | 2 Comments   

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 Read More...

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

High CPU issues that are specific to SQL Server 2000 installations and few with SQL 2005 too!
20 September 07 08:40 AM | SQL Master | 2 Comments   

Here comes another Frequently Asked Question (FAQ) on the forums and Frequently Posted Blog (FPB) here about high cpu issues on the SQL Server 2000 instances. Looking at high cpu spiks and performace issues is a common problem in all SQL Server installations, Read More...

Filed under: performance, sql server, query, blocking, databases, cpu, kba, execution plan, high cpu, resources, FAQ, blogs, backups

Make use of tools and utilities that are available in SQL Server - performance & tuning
08 July 07 05:19 AM | SQL Master | 1 Comments   

There are various tools available within SQL Server installation such as SQLDIag, SQLDumper, PSSDiag (to be downloaded as a seperate tool), SYSMON(PERFMON) and Profiler etc. Among these SqlDiag and Sqldumper are most important to get more information Read More...

Filed under: tuning, performance, query, error, troubleshoot, script, kba, sqldiag, sqldumper