Database Connection Sporadically Running Very Slow?

May 25, 2010

My web app connects to my database server which is on my lan. It is usually very quick but once in a while the connection is extremely slow and has even causing errors by timing out. The server only has 1 gb of memory so I'm going to upgrade to at least 4 gb.

View 3 Replies


Similar Messages:

Databases :: Losing Connection When Running Long Running Oracle Procedure?

Jul 1, 2010

I am executing a long-running Oracle stored procedure from .NET. The procedure takes about three hours to run. Ideally, the user should be able to kick off the procedure, close the browser, and come back later to check the results.

The problem is that the connection to the Oracle procedure is lost after exactly an hour. As you would expect, the Oracle procedre runs to completion if it is executed from SQL Plus. Strangely enough, it will also run to completion if I run in debug mode on my local machine (I start two threads, one of which executes the procedure. I set a breakpoint on the second thread).

Here is my connection string:

data source= (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=serverx)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=TestSID)))

Some relevant sections from web.config:

<sessionState mode="InProc" cookieless="false" timeout="3000" stateNetworkTimeout="72000"/>
<httpRuntime executionTimeout="18000" maxRequestLength="2097151" />

Any thoughts as to why the connection is being lost in exactly an hour, and what I can do to maintain the connection until the procedure finishes?

View 1 Replies

Slow Of First Page - Running On Windows / IIS

Mar 16, 2011

I'm more into the LAMP stack, but I've been asked to work on a site that is running Windows and IIS 2008. I'm a beginner with IIS, so please be patient with me on this, and please ask me to provide more information if that is needed to determine. I read the answer here (Slow first page load on asp.net site), but it seems like if I go to the site with one browser it takes long to load the first page, then fast on all other pages, then if I open up another browser, it's the same thing, so it's not something that is saved on the server, but per session? Is there a way to have the application running at all times? Right now it is taking 12 to 15 seconds for the first page to load. I have access to the WebControlCenter and FTP.

View 3 Replies

SQL Server :: Query Is Running Very Slow

Mar 19, 2011

The below SQL query is running extremely slow. Im using this query on other tables and its processing about 5 rows per second. The below version is running 1 row every 10 seconds when @SQLNew is executed.

[Code]....

View 5 Replies

Performance - Application Running Slow?

Feb 22, 2011

There's a web app I've been assigned to, which is running very slow. It is a site that sells products so it is database driven, however even pages that do not query the database are loading very slow. The pages use master pages, and the code is in VB.NETI checked with fiddler and the time it takes to load basic (non database driven) pages are about 5.5 seconds on average.

What are some tools that can help me determine the cause of the slow speeds, and any recommendations as to how to speed it up, or potential issues that could cause it?UpdateSo I messed around with the code piece by piece as I wasn't getting anywhere with these tools. As soon as I remove master pages, and I include the same code that's on the master pages in the .aspx page itself, the speed improves drastically (approximately 5 times faster load times).What might cause the master pages to cause load times to slow down so much?

View 4 Replies

C# - Automapper Running Extremely Slow On Mapping 1400 Records?

Nov 9, 2010

I am using AUtomapper which I am very impressed with however, I have a complex object with many nested collections. I'm using Telerik OpenAccess and it returns the 1400 records fast but when I pass it to Automapper and it slows to a ridiculous crawl. Here is my code for reference:

List<DAL.Event> query = httpContext.Events.Where(e => e.Inactive != true && e.Event_Locations != null).ToList();
Mapper.CreateMap<DAL.Event, EventDTO>();
Mapper.CreateMap<DAL.Event_Association, EventAssociationDTO>(); [code]....

View 2 Replies

SQL REMOTE Connection Is EXTREMELY Slow?

Jan 18, 2010

I've set up a msSQL remote connection on a GoDaddy shared hosting account (known as Direct Database Access).I'm doing some javascript/HTML/css work on the site and don't need/want to have to download/manage a separate database.The remote connection works and the pages load as expected. However, each time I request a DB driven page in my browser it takes about 2-4 minutes before the page is sent/downloaded.Could this be a limitation set by godaddy to discourage connecting to the database remotely?Is there anyway to set up a "proxy" on the production server to get the query results?Are there any alternative methods for connecting to the DB you could suggest?Should I just stop whining about it and setup a local copy of the database?

View 1 Replies

SQL Server :: Slow Running Query Based On Multiple Tables Using Joins

Nov 15, 2010

One of my peer wrote a query based on multiple tables using joins. One of the table is in a different database The query was taking much time

1. Create an SP
2. Create a temp table and copy all records from the external db
3. Avoid using Left Join as much as possible and use Inner Join
4. Create and use indexes
5. Remove tables/columns that are not necessary

In this scenario, I would like to suggest to use Covering Index, but how can it be created for multiple tables and a temp table?

View 3 Replies

Informix Odbc Connection Slow To Open

Apr 28, 2010

I have an application that takes a long time to open odbc connections (like 20 sec) also takes forever using arcmap and arcsde but when I try the connection on the odbc data source administrator, it tests it really fast. Does anyone have any idea of what my be causing this? btw the application works fine in another computer with another database

View 2 Replies

C# - Simulating Slow Internet Connection On Localhost

Apr 15, 2010

iam using c#,asp.net and iis, i want to simulate slow internet connection on my pc for testing my app. is it possible i can control bandwidth of iis. System.Threading.Thread.Sleep(someDuration); in c# file.

View 3 Replies

What's Standard Practice To Make Sure One Slow Running Page Doesn't Affect Other Pages

Aug 31, 2010

Page A loads very fast; Page B loads very slowly and does some CPU-intensive things on the web server. I noticed that if someone is loading Page B, then Page A also loads slowly - for ALL users. What is the standard practice for making sure this doesn't happen? If multiple users are loading Page B at the same time then Page A is ridiculously slow. Is there an IIS setting, web.config setting, or hardware configuration I could use to make sure that the fast-loading pages aren't bogged down by other pages that need more time to load?

View 1 Replies

VS 2013 - Internet Explorer To Run Slow And Return Error Message Asking To Stop Running This Script

Nov 27, 2014

I'm new in using C# in ASP.net My code is causing Internet Explorer to run slow and return error message asking to stop running this script.

When I use the "Select *...", it return about 700 rows of records and it cause the error.

When I use another SQL "Select NOC0854....", filtering some records, it return about 300 rows of records and no error message appear.

How I can improve my code so that I can retrieve all records from my table? I think 700 rows of records doesn't seem a lot, maybe my code is not correct?

Code:
//cmd.CommandText = "Select * from PTH3759";
cmd.CommandText = "SELECT NOC0854 from PTH3759 WHERE HID0019 >= TO_DATE('11/01/2014','MM/DD/YYYY') AND HID0019 <= TO_DATE('11/28/2014','MM/DD/YYYY')";
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
if (dr.HasRows) {
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
}

View 2 Replies

Running Sites On "localhost" Is Extremeley Slow?

Mar 5, 2010

Having real trouble using my local host to test sites. It runs extremely slow! Sometimes up to a minute to load a page. I'm using firefox and the sites i'm testing run fine on other developers in my office local machines/ on the production server.

I've gone through the normal things :-

Disabled IPv6
Not running in debug mood Put the site in the highest app pool (High Isolated) on IIS 6.Taking of firewalls etc.The problem only seems to occur when hitting pages which contain some form of .net code in the code-behind.

Appreciate that this a little bit of a vague topic / stab in the dark but would appreciate any sort of advice - it's horrible waiting a minute each refresh to try out a change!

View 2 Replies

C# - Connection Reset With Long Running Process?

Mar 18, 2010

In an asp.net web form, I keep getting a connection reset error message. The page is doing a some long running processing (about 2-5 minutes).

I have no problem when the web request comes from the same machine as the web server. But when the request originates across the network, I get a connection reset error about 1:30 or 2 minutes into waiting for a response.

I have set the in web.config for this application and put the application it's own application pool.

What else can I try?

Edit

The purpose of this page is to accept input from the user, calculate something, and send the result back to them. The long running calculation isn't something I can offload until a later time.

View 2 Replies

Forms Data Controls :: ListView Connection Error - Database Schema Could Not Be Retrieved For This Connection?

Jul 23, 2010

I am using VS2008 and oracle 10g ODP.Net. The oracle database that I used in the connection is working and tested it using sql plus.The connection string when used in a GriDView works perfectly. Now when I created a new listview control with the same connection it gives an error.Database schema could not be retrieved for this connection. Please make sure connection settings are correct and the database is online

Object reference not set to an instance of an object at VSDataObjectSupport (478,6)

View 2 Replies

C# - Connection Property Hasn't Been Initialized While Running Application From IIS

Apr 4, 2011

I have one intranet based application.I have set windows authentication for it in Web.config as well as from IIS settings. While running my application through the source code, it works fine but while running from directly IIS then its giving me:

"Connection property has not been initialized"

View 1 Replies

AJAX :: Login Control Fires Sporadically?

Oct 19, 2010

Login Control fires sporadically?

[Code]...

View 3 Replies

Firefox Sporadically Displays File Stream Instead Of A Document?

Feb 22, 2010

When user requests to download a document, I'm writing out a PDF file to HttpResponse using HttpResponse.OutputStream.Write method. It works in every browser except Firefox(3.5.8). In Firefox it sometimes displays the file and sometimes it displays the actual byte stream. When it displays a byte stream, http response is never finished. I see 'transferring data' status and the byte stream ends with EOF. After some time, I get 'connection was reset' window.

Here is response header:

HTTP/1.1 200 OK
Cache-Control: no-cache
Pragma: no-cache
Content-Length: 103185
Content-Type: application/pdf
Expires: -1
Server: Microsoft-IIS/7.0
X-AspNet-Version: 2.0.50727
Content-Description: stuff.pdf
Content-Disposition: inline;filename="stuff.pdf"
X-Powered-By: ASP.NET
Date: Mon, 22 Feb 2010 16:15:38 GMT

View 5 Replies

Security :: Forms Authentication Through The Membership Provider Sporadically Not Working

May 3, 2010

I have implemented the .Net Membership provider with my website which is, for the most part, working well. However, occasionally a user will try and login and nothing will happen. There will be no error, they will just hit "Submit" from the login screen and continue to the homepage as an unauthenticated user. This behavior persists until they clear their web cache, or restart their machine... which makes me think it's some kind of cookie expiration error?

Does anyone have any ideas on how to troubleshoot this?

Here is the relevant section of my webconfig:

<membership defaultProvider="AspNetSqlMembershipProvider">
<providers>
<clear/>
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="ASPWebAuthConnectionString" maxInvalidPasswordAttempts="10000000" enablePasswordRetrieval="false" enablePasswordReset="true" applicationName="nvpumps"
requiresUniqueEmail="false" minRequiredNonalphanumericCharacters="0" minRequiredPasswordLength="5" requiresQuestionAndAnswer="false"/>
</providers>
</membership>

View 3 Replies

Access :: Database - Datareader Is Very Slow

Apr 9, 2010

I'm using the datareader on an access database, and its very slow. The query runs in access in about 1/2 second, when run with a datareader it takes 25 seconds. Code below

[Code]....

View 7 Replies

Web Forms :: Fetching Of Files Saved In Database Using Generic Handler Is Slow

Jul 8, 2013

I have used [URL]....

above method to save and retreve files from sql server database. I have uploaded around 50-60 images as jpg. But it taking so much time to get display online. but it's working faster when accessing from local database. 

There's the page where images are displaying [URL]....

Is the speed for images retreiving from sql database is  slower as compared to retrieving images from folder..?
 
.vb code:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
scroll = fillbannerpics()
End If
End Sub

[CODE]..

View 1 Replies

Web Forms :: How To Take Application Near Clock Icon,near Local Area Connection Icon In Running Mode

Jul 8, 2010

i am develpping a alarm application when user minimized this it should be minimized appear near the system clock,local area connection icon(as hidden icon).

View 3 Replies

Visual Studio :: Error Unable To Add Data Connection. ExecuteScalar Requires An Open And Available Connection. The Connection's Current State Is Closed?

Sep 13, 2010

I'm using Visual Studio 2008, and my database is SQL Server 2000.

I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful.

But when I click OK, I get the error:

Unable to add data connection. ExecuteScalar requires an open and available connection. The connection's current state is closed.

View 3 Replies

Databases :: Database Running Status Using Ping?

Feb 12, 2011

I want to test the Oracle and SQL servers running are Up or Down. Currently, I am using the following way to check the connection.. for example Oracle connection as ..

Dim cn As OracleConnection
cn = New OracleConnection(ConnStr)
cn.Open()

This is working fine. But, is there any other way to check the DB up status like Ping.

View 1 Replies

DataSource Controls :: Cannot Open Database "easysms" - Make A Connection To A MS SQL Database?

Jun 5, 2010

First off, I am just getting started with ASP.NET so I expect this is something that I am doing.

i am trying to make a connection to a MS SQL database on my local machine.

I have the following in web.config

[code]....

View 4 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved