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

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

SQLConnection Open Close Performance issue

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

Hi, I have interesting and depressing problems in querying sql statements with some machines in my environment. Firstly i will try to summarize my environment and try to define the problem. 

There are seven application servers and an sql server in my environment. Each of these seven application servers have a windows service application that runs sql statements on the sql server. There are some performance problems at 3 of 7 machines. I write a simple code and test this code on all application servers. The code as follows:

static void Main(string[] args)
   DateTime processgeneric = DateTime.Now;
   DateTime processstart = DateTime.Now;
   Console.WriteLine("Application started: " + ((TimeSpan)(DateTime.Now - processstart)).TotalMilliseconds.ToString());
   processstart = DateTime.Now;
   SqlConnection sqlConn = new SqlConnection("Data Source=XXX.XXX.XXX.XXX;Initial Catalog=DBNAME;User Id=USER;Password=PWD;");
   string sql = "SELECT * FROM [DBNAME].[dbo].[T

View Complete Post

More Related Resource Links

Check-out issue when opening a document from a document library when a read-only copy is open

We have an issue when a user has a read-only copy of a document from SharePoint open and then tries to check-out and edit another copy of the document (i.e. from the document library) the checked out copy is not connected to the web server. For the user it will look the same they will make edits, save and then close, but when they do so the document is not updated in SharePoint - it may be saved locally in their SP drafts, but the user will think that they have lost their version. We then get the checked out to another user error and you have to discard changes to get the document working again. Steps to reproduce this issue: * click on the name of a office doc on a Document Library * Make sure "Read Only" is selected and click "ok" * Minimize open document * click on the same file on the Document Library * Make sure "check out and edit" is selected and the "Use my local drafts folder" checkbox is ticked. Select OK. * Edit document and press save. Changes are never saved back in SharePoint, they are only on the local draft. We are using MOSS with SP2. Clients are on Office 2003 and 2007 Is this normal behaviour? Is there anything that can be done to prevent this from happening?

Wickedly Strange .Net WPF Performance Problem Dissapeers with Windows 7 Performance Monitor Open

Hello Everyone, I have been developing one large and complex WPF application for 13 months now, all is going well and especially tonight as I now have some sort of clue or hint to what I have been seing now for quite some time.  Here is the rundown. 1) Running on i5 processor with 4GB RAM and Windows 7 2) The application was developed all in .Net 4.0, WPF C#. 3) It is heavily GUI intensive and also uses Entity Framework Detached for Database Access. 4) Is multi-threaded / multi-tasking. I am a nutcase when it comes to testing.  Since my graphical application heavily depends upon performance and determinsm (please somebody don't start with the C++ vs .Net on here) and has been performing great FOR THE MOST PART.  Every once in a while, I see that the application runs into the weeds for 5 or 6 seconds and the interface is unresponsive.  I have this thing tuned finely too.  Well now toward the end of development I have finally had to face that bug so to speak.  I can force it by clicking spastically on my buttons causing an event storm and making the system update the GUI.  SO!  Great start, I can now cause the problem on a regular basis (for you youngsters that is actually a good thing)!  Alright, so I start with the easiest investigative tool, CNTRL - ALT - DEL into Windows 7 Performance Monitor.  As you can tell from

Detecting a page close using GetCallbackEventReference IIS6/IIS7 Issue

I have a popup page that when closed,  initiates a server side function that updates a DB table.  After looking at countless posts, I was able to use the following code (partial) to generate the callback when the window closes. The problem I'm having is that it works great on a server with IIS7, but the event doesn't fire on one with IIS6. Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load    If Not IsPostBack Then        Dim callBackReference As String = Page.ClientScript.GetCallbackEventReference(Me, "arg", "LogOutUser", "", True)        Dim logOutUserCallBackScript As String = "function LogOutUserCallBack(arg, context) { " & callBackReference & "; }"       Me.ClientScript.RegisterClientScriptBlock(Me.GetType(), "LogOutUserCallBack", logOutUserCallBackScript, True)    End If  End Sub      Public Function GetCallbackResult() As String Implements System.Web.UI.ICallbackEventHandler.GetCallbackResult               Return _callBackStatus    End Function     Public Sub RaiseCallbackEvent(ByVal eventA

Performance Issue on SQL 2008 Box

Will SSRS and SSIS running on the same machine would hinders the perfromance of a database engine. 1. If so to what extent? 2. How do you tackle this kind of issue. 3. Is there a way you can separate these services from running on the same machine. The machine also has a OLTP database running on it.

XOML only workflow performance issue while creating

  In our application we are using XOML workflow and create workflow instance using workflowRuntime.CreateWorkflow(workflow, ruleReader, workflowParameters) where workflow and ruleReader are objects of XMLReader created using XmlReader.Create().For one of our business process automation we have developed XOML only workflow which has 35 states and 95 events. When we try creating an instance of the workflows it is taking more time and the time taken to create the instance is 3 min.Can any one suggest is there any other way to create workflow instance of XOML only workflows other than workflowRuntime.CreateWorkflow(workflow, ruleReader, workflowParameters)Your help is higly appreciated.Environment:    VS 2008    ASP.NET 3.5    WWF 3.5    XP  

Gridview Performance Issue

Hi All, I have one ASP.NET Application (VS.NET 2005). In that i have one scenario where i have to display 500 records per page (Not less than that bcoz this is client requirement to display 500 records per page) in the Gridview. This functionality is working fine but the application is becoming very slow. Can anybody tell me the solution for increasing performance in this case ???? VERY URGENT...PLZ REPLY SOON Thanks, Biswajit

GridView crashes when user enters html open "<" or close ">" characters in a textbox

My GridView is bound to a sql data source and allows editing of fields. Coding is in C# and JavaScript. Using Visual Studio 2008 in test mode, if I enter a less-than "<" or greater-than ">" character in a GridView textbox an error is immediately thrown upon pressing enter: "Microsoft Visual StudioMirosoft JScript runtime error:Sys.WebForms.PageRequestManagerServerErrorException: An unknown erroroccurred while processing the request on the server. The status dode returnedfrom the server was: 500"When the < or > is entered in production, the page aborts and loads the application start page. I need to be able to catch and replace those characters BEFORE the error is thrown. I've tried hooking OnTextChange code to the textboxes, but the error is thrown as soon as I press enter...the OnTextChange code never runs. Any help will be greatly appreciated.

Windows 7 window.open() and - target issue



In Windows 7 when I use window.open(url, "_MyWindow") a new browser window opens every time I click.

Expected behaviour is - URL is replaced in the browser window with the same target attribute (_MyWindow) if it's already open.

Any suggestion/workaround is greatly appreciated.

All works fine in any other OS/IE config, even on XP/IE8.




same issue appears using <a href=http://www.microsoft.com target="_MyWindow">Open link</a>

.NET 4 Performance Issue String IndexOf



I have a performance issue with the new dot net 4.0 framework.

When i use the function String.IndexOf(string, stringcomparison.ordinalignorecase) my execution time is much higher than framework 3.5 (i had 30ms in a loop for 3.5 and 210ms in framework 4)

All other StringComparison mode are really good in framework 4.

Is there an explanation?

performance issue


i am having an issue in queying a table. This is something thats happening since the last 2 days. whenever i try to open a table (rightclick --> open table ) it errors  out saying the query time out period elapsed before the completion of the operation or server is not responding. But when i query select * from tablename..it is taking some time but is returning the results. The query time out period is set to 0(indefinite time out). we have never seen this kind of issue before. There are no open transactions either to assume that something is locking the system(dbcc opentran returns there are no open trans). Wondering why this is happening and also the performance of the system has gone down completely. Please help us in this issue. I checked the indexes for fragmentation and could see in some of them avg_fragementaton_percent like 60, 70, 80. i guess it is not good to have high such a value, so i ran dbcc reindex but still did not improve the performance. the avg_fragmentation was still the same.

Please advice. 

Issue with WCF performance


We have several WCF (3.5 hosted in IIS7) web services that are having some strange and inconsistent performance issues. In some environments they run fairly quickly. In others they time-out even if we significantly increase the timeout. We have tried all of the advice for performance tuning an IIS 7 hosted WCF service to no avail.

The svc log however shows some odd beheavior I am not sure how to interpret. I will get a message saying Opened System.ServiceModel.InstanceContext/..... The next message will say "A message was read". all good except it takes over six minutes sometimes. I do not follow these logs well enough to understand what could be causing this.

If anybody could provide any help or guidance, it would be greatly appreciated.

Best regards,


 Additional information: Just realized that the servers where we are having the large delays reading the message have Symantec "Data Endpoint Security" installed. Seems like it could be related. anybody have familiarity with this AV client and WCF?

Performance Issue.



I have a query which involves a table and a function. Table has got around 59 crores of records and the function returns 56k records. There is a inner join between with function being on the left side. This query takes around 2 minutes to execute. I wanna improve the performance to few seconds.

I made sure that the table has all required indexes but still was not able to improve the performance.

Please suggest what else i can do to improve performance.







Sql Server compact Edition Performance issue

I was  trying to insert a .wav file to sql server CE..The file is of size 1 Mb,but it takes a long time to perform the action (more than 1 min).Anybody have solution ? please help me..

Performance Issue


we did a performance check on production and found that an object is missing from the Layout page which causes the below error frequently.

 When we check the log file we get the below error

1. SearchUpgradeGetKeywordPropertyBag keywordsPropertyBag is null

2. Cannot open file "Resources.en-US.resx" for reading.
(#3: Cannot open file "Resources.resx" for reading.)


Most of the time SearchUpgrade and Cannot open file error are followed by While Initializing navigation error.

And we receive a deadlock error in the IIS(ISAPI.dll) at the same time when we receive this error.

Is there any script for Open/Close sql-server 2008 ?


Is there any script (any batch file) for Open/Close sql-server 2008 ?

thank's in advance

Check out issue - authentication modal dialog on every checkout, Explorer View or Open With Windows



I got users that have an issue when trying to check out document, using the Explorer View or using Open With Windows Explorer.

Users are on Vista, IE 7 and Win 7, IE8

I have seen this Warning in the Application Event log:

"WMI ADAP was unable to retrieve data from the PerfLib subkey: SYSTEM\CurrentControlSet\Services\SSO\Performance\Library, error code: 0x80041009"

Any help would be very much appreciated!


vs 2010 performance issue


we have migrated our application from vs 2005 to 2010 we found that page loading time is increased 

any idea why this is happing or how to improve it 

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