Browse by Tags

• 3gb
• 4014
• awe
• consolidation
• edition
• enterprise
• error
• installation
• kba
• management
• memory
• multiple
• netmon
• pae
• planning
• security
• sql server
• ssis
• trace
• update
• windows

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

More than 3GB memory is not used even though boot.ini has these switches on /3GB /PAE /AWE.
23 August 07 02:33 AM | SQL Master | 3 Comments   

Yet another AWE memory settings blog post here that I'm posting for the issues we have had recently. Before going into details review about 3GBPAE blurb here and also refer to this KBA274750 to enable more than 2GB memory within your SQL Server Enterprise Read More...

Filed under: performance, sql server, security, memory, windows, instances, enterprise, pae, awe, 3gb, edition

SQL Server consolidation & keeping up performance at the same time
15 June 07 02:03 AM | SQL Master | 1 Comments   

So what are your options in Server consolidation and not to harm the performance for the applications that are happily sitting across your data center and you have this mammoth task to consolidate the servers to save physical space etc. No doubt that Read More...

Filed under: instances, planning, consolidation, performance, sql server, management, multiple