.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

How to improve performance on an instance with large I/O activity?

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :Sql Server

I have a mirrored instance that throws up 'unsent log' and 'unrecovered log' errors. Everytime it does the I/O activity shoots up. I was wondering what can be done to improve this?

Extra memory? More processing power?

What if I spread the filegroups across different disks? Would this help?

View Complete Post

More Related Resource Links

How to improve performance on an instance with large I/O activity?


I have a mirrored instance that throws up 'unsent log' and 'unrecovered log' errors. Everytime it does the I/O activity shoots up. I was wondering what can be done to improve this?

Extra memory? More processing power?

What if I spread the filegroups across different disks? Would this help?

How to improve the performance of ASP.NET MVC web applications

It is an in depth analysis of a Digg-like site and how it went from serving (on a test machine) 6 req/sec to 390 req/sec.

The biggest gain, 74 req/sec to 390 req/sec happened when he introduced data caching and another 25 req/sec where gained when he introduced the compilation of LINQ queries.

Tips to Improve Your ASP.NET Web site performance

ASP.NET has been developed with lots of features which makes developer life easy. Start from ViewState, PostBack, Server Controls , User Controls and etc. All of them can make your web development experience fun and easy, but improper use of them can cause your site performance slowdown. Most of the controls generate overhead to the client and server. Therefore in this article, I I will list out about things you can do and don't to improve your ASP.NET website performance.

Best Coding Techniques To Improve Performance for SharePoint Applications

As more developers write custom code by using the SharePoint Object Model, they encounter common issues that can affect application performance.

The following areas reflect the main issues encountered by developers as they write custom code by using the SharePoint object model:

§ Disposing of SharePoint objects

§ Caching data and objects

§ Writing code that is scalable

Event Tracing: Improve Debugging And Performance Tuning With ETW


Event Tracing for Windows (ETW) provides general-purpose, high-speed tracing of events raised by both user-mode applications and kernel-mode device drivers. Learn how ETW can improve your development and debugging work.

Dr. Insung Park and Ricky Buch

MSDN Magazine April 2007

IIS 6.0: New Features Improve Your Web Server's Performance, Reliability, and Scalability


As the Web evolves, so does the role that Internet servers play. The Internet has seen the growth of e-commerce, B2B business, collaboration, streaming and other new media, and these new applications require new features to meet increasingly complex needs. Microsoft Internet Information Services (IIS) has many of the features today's mature Web sites need. This article outlines the features in the upcoming version 6.0 and discusses how they promote better scalability, reliability, and performance. Features such as Remote administration, caching, and metabase improvements, as well as custom isolation and security enhancements, make IIS 6.0 the Web server of the future.

George Shepherd

MSDN Magazine March 2002

Tip #107 Did you know . How to improve debugging performance for MVC2 application in Visual Studio 2

VS2010 Ultimate included IntelliTrace functionality by default.  IntelliTrace captures events (e.g. exceptions), and can affect performance of debugging. The typical performance hit is about 5% in the default mode (collection can be increased to...(read more)

How can I improve the performance of batch inserts with the JDBC driver?

In our testing, batch inserts are more than 4 times faster on Oracle with the Oracle JDBC driver than on SQL Server with either the Microsoft or jTDS JDBC drivers on the same hardware.  The issue appears to be with the JDBC driver, not the database server.  We have run tests with SQL Server 2005/2008 on a number of machines with similar results. The following code shows a simplified example of the code we are executing.  It uses a 2 column table which has an index on the id column.  In the test program we are inserting 100k rows with a batch size of 10k.  Any suggestions on improving the performance with the SQL Server JDBC driver?   private void testBatchInserts(Connection conn, int rows, int batchSize) throws SQLException {     String sql = "INSERT INTO Bench (id, name) VALUES (?, ?)";     conn.setAutoCommit(false);     PreparedStatement stmt = conn.prepareStatement(sql);     int batchCount = 0;     // For each row...     for (int i = 1; i <= rows; i++) {       // Create the record       stmt.setInt(1, i);       stmt.setString(2, "ROW #" + i);       // Add it to the batch       stmt.addBatch(); &nb

Multiple databases on same instance - performance hit?

Hi I am not a SQL person to please excuse me if my terminology is wrong :) We are running SQL 2005 at the moment on Windows 2003 SP2 servers. We have multiple SQL servers spread around in each of our data centres. We have an application we're going to be bringing in that needs it's own SQL database. We need to decide whether we build a dedicated SQL server for this or just create a new database on an exisiting SQL instance. The advantages of the former are that we don't max out any existing servers and affect the performance of other databases, whereas with the latter we save the cost of having to build a new server. For those of you that use SQL heavily, what's the general way of doing things? I know that SQL is memory, disk intensive etc so not sure.

How to read and analyze a very large log file with high efficiency and performance?

It is a very large .txt file (more than 3M), and produced everyday, the content is user's system log like below: 2007-11-01 18:20:42,983 [4520] INFO GetXXX() SERVICE START2007-11-01 18:21:42,983 [4520] WARING USER ACCESS DENIED2007-11-01 18:22:42,983 [4520] ERROR INPUT PARAMETER IS NULL CAN NOT CONVERT TO INT322007-11-01 18:23:59,968 [4520] INFO USER LOGOUT   Any idea? Thanks.

Exception "The activity with display name 'Flowchart' has already been associated with an instance

Using VS 2010 RTM. I have rehosted the desginer and provided a "test" button which runs the WF shown in the desginer, the code for running the WF is simple:  void OnTestWorkflowCommandHandler(object parameter) { ActivityBuilder designerBuilder = (ActivityBuilder)WFDesinger.Context.Services.GetService<ModelTreeManager>().Root.GetCurrentValue(); WorkflowInvoker invoker = new WorkflowInvoker(designerBuilder.Implementation); var se = invoker.Invoke(); it works fine, BUTThe root activity is a flowchart , if I start messing with the desginer and adding sequences and going back and forth to child activities and try to test(run) the WF I get the exception:The activity with display name 'Flowchart' has already been associated with an instance.  Once associated with an instance an activity's metadata cannot be manipulated.  This error might also indicate that you are attempting to execute a workflow whose root activity is actually part of another workflow.

improve performance

i have a problem about how to improve the performance because when i retrieve around 5 thouands record to datatable and bind to datagird, the speed is slow. but when i execute the sql in the sybase. the execute time is fast(reasonable) what is the probelm? how to improve the perforamce. 

The SQL Server performance counter 'Page Splits/sec' (instance 'N/A') of object 'SQLServer:Acce

I am getting these page split errors every 5 minutes I have tried everything reindexing rebuilding working with different fill factor values But nothing seems to effect this problem. The threshold is now set to 100 (what the max threshold number i can set the alert to ?) Also please let me know how to get rid of the pagesplit alerts. thanks

How to improve performance

I have developed an application with two pages 'AddClient' and 'EditClient' and deployed it. It works fine but on the 'EditCient' page it takes about 8-9 seconds to populate clients information after a client has been selected from the DropDownList. I have around 40 controls, 5 update panels and a BingMap on this page. On Page Load I'm populating 8 DropDownLists from dataset and each DropDownLists has about 150 items. Clients DropDownList has about 6000 items. How can I improve the performance? Any help/ suggestions would be greatly appreciated..  

Creating an Activity Instance for WorkflowInvoker



I want to create an Activity to run through a TestMethod, but the following Fails


IObjectScope scope = RTODataLayer.Private.ObjectScopeProvider1.GetNewObjectScope();

RTODataLayer.RequestedDate date = WorkflowInvoker.Invoke(new CreateRequestedDate() { Scope = scope, Active = true, FromDate = DateTime.Now.AddDays(10), ToDate = DateTime.Now.AddDays(15), RequestID = request.RequestID, TypeID = 1, WorkingDays = 5 });

Error    142    Cannot implicitly convert type 'Telerik.OpenAccess.IObjectScope' to 'System.Activities.InArgument<Telerik.OpenAccess.IObjectScope>'    D:\websites\workflow\RTO.UnitTests\RTO.Testing\Workflows\Approval.cs    19    106    RTO.Testing

How do I pass in the scope object?...in my actual master XAML file I maintain the scope in the workflow, but I want to test the individual components.




improve performance of gird on page index change


i am using data gridview asp.net  control and i bind it dynamically, gird displayed 80,000 thousands records so i am using paging techniques,on each page gird display 10 record so when i am change page each time gird should filled 80.000 thousands records so how could i bind gird from pageIndex,pageSize rather than bind it whole records

my code is below

BAL,DAL techniques so Method for data gird binding is following

private void FillGrdTendersDeptWise()
        tender objTdr = new tender();
            DataTable dt = new DataTable();
            dt = objTdr.GetAllTenderDeptWise();

            grdTender.DataSource = dt;

        catch { }

page index change

Does anybody know anything about converting search criteria to Binary to improve performance?

Does anybody know anything about converting search criteria to Binary to improve performance?
Mr Shaw
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend