Browse by Tags

SQL Server - Deploying Database Mirroring and Clustering parallely on same machine, performance and failover support?

Published 8 May 8 3:42 AM | SSQA.net

When you think about high availability in SQL Server then you would think about Clustering and in addition to this within 2005 version we have Database Mirroring too that can provide automated failover support to your database server applications. By...

Filed under: sql server, performance, high availability, best practices, cluster, support, database mirroring, instances, multiple, failover, scalability

Copy the SQL Server instances list from Enterprise Manager using vbscript

Published 7 February 8 2:34 AM | SSQA.net

As you may be aware you can take help of Registry settings in order to copy the SQL Server list that are managed from the Central Managed server. I have seen this VBScript posted by Mohammed U posted the following script, you can save it as .VBS that...

Filed under: sql server, microsoft, script, instances, enterprise manager, copy, vbscript

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

More than 3GB memory is not used even though boot.ini has these switches on /3GB /PAE /AWE.

Published 23 August 7 4:33 AM | SSQA.net

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

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

SQL Server consolidation & keeping up performance at the same time

Published 15 June 7 4:3 AM | SSQA.net

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

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