Slow Database Connection Over VPN

I just found out the response time of open a connection or execute a SQL command over VPN is very slow. It takes around 150ms for each round trip. If the same program run on LAN, it takes less than 1ms. I understand that VPN may have encryption and thus have a bit delay. However, if the delay happens whethever I make a SQL call, it will be unacceptable. Is there anything that I have missed out? If the delay occurs once only, it will be still great. (I think this is the point of connection pooling. Right?) However, it's really bad if the delay occurs each time I call SQL. Please help!

View Replies


ADVERTISEMENT

Slow Database Connection...workaround

I have a portal site that has many iframes loading various pages. One of the iframes requires data from a database that has a slow connection and right now there is nothing we can do about the slow connection and is something we have to live with.
What seems to be happening though is that even though each page is loading seperatly in an iframe, when the page loads with the slow connection, it seems to hold up processing on the server for the other frames until the connection has been established with the server. It can be something like 10 seconds. I am guessing trying to establish the connection is holding up the worker process on IIS???
So I am trying to find a workaround bearing in mind there is nothing we can do about the slow connection for the time being? Does anyone have any suggestions? One I am thinking of is forcing this frame to load last so at least the other frames are not being held up. Another is maybe to use a seperate thread, but does anyone have any idea on this?
Thanks in advance 
 
 

View Replies View Related

Very Slow Connection

Hello,
We have Sql Server installed on the Windows 2000 machine.
There are 2 databases that the employees access on it.
When the machine is just started, there are no problems but after some time the connections get really really slow and then eventually become impossible to connect. We did not have this problem before until we had a computer crash and then Sql server was installed on a new machine. The problems started here. We had 64mb of ram and we put in another 64mb thinking this would solve it but it did not.
On the task manager the cpu percentage stays constant at 100% and the virtual memory increases and increases very slowly until it has reached it's maximum (which is 600mb).
Any information would be greatly appreciated.
Thanks very much,
Kostas

View Replies View Related

Slow Sql Connection

I am running an IIS, windows NT and Sql 7.0
My asp pages load very slow whenever the database is accessed. All the database scripts are in stored procedures. The pages load very fast when they are run on personal web server. I will really appreciate any suggestion to help fix the problem

Thanks

Godwin
IMS

View Replies View Related

Slow ODBC Connection.

Hi All

We have a web server using iss4.0 and coldfusion. Connection to the database server SQL 7.0 is thru odbc. Would appreciate if some one could explain how to increase the performace web server performace. Any special setting required on iss orcold fusion or SQL

regards
rajeev

View Replies View Related

Slow Response From A 32 Bit To 64 Bit Connection.

Here is the configuration we have at our site:
64 bit virtual server - Clustered 64-bit SQL Server 2005 Standard SP2 listening on port 1433.

32 bit virtual server - 32-bit application that connects to above SQL Server 2005 via standard OLEDB driver installed with windows (String utilized: Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=applicationdb;Data Source=ServerInstanceName).

We are experiencing a slow reponse of 45 sec to more than a minute on a simple select statement on a table having 5000 rows.

The same select statement on the Server locally in Studio returns results back in 2 seconds or less. But from Stuido on any other desktop (remote) it takes 45 secs or more. Same slow response is seen by the application which is using OLEDB.

I've looked into some of the Server parameters but didn't find any clues.

Any help is greatly appreciated.

View Replies View Related

Slow Connection Problem

I have a desktop and a laptop that connect to a SQL Server machine on our network. From the desktop when I run a particular query it takes 20 sec. to return 71000 rows. From the laptop it takes 5 seconds to return the same results.

Both machines are running Windows XP Pro Sp2. I checked with others that I work with, and their results mirror my laptop (about 5 sec.). I checked the Client Network settings, ODBC drivers, etc. All are the same between the two machines.

I have a VFP app that accesses the same server, and again similar results when running from the desktop vs. the laptop.

What could explain the difference in time (20 sec. vs. 5 sec.)?

 

 

View Replies View Related

Connection To SqlServer Not Responding Or Very Slow

I am trying to connect sql server on my local system to view databases, or any server on LAN. But Enterprise Manager is not responding to show me databases. Even my application takes a long time to get connection to database. Would you please help me out. That where is the problem?

View Replies View Related

OLAP Manager Connection Slow

Morning,

I have several data analysts with OLAP Manager installed on their NT workstations. They all point to an NT/SQL Server. I've got all the latest service paks. But for some reason, their connection to the server is slow. The strange this is...if they connect to each other's workstations using OLAP Manager, the connection is fine.

View Replies View Related

Slow Connection To SQL Server 2005

Hi!
I have a SQLServer 2005 running om a 64bit cluster. It is used to run a SharePoint 2007 portal. My problem is that the access to the database from the other servers in the farm is very slow.

I made a test program in C# that creates a standard .Net sqlConnection and runs a simple query 100 times. When run on the database server it takes less than a second, but when I run it from the web frontend server it takes 30 seconds. It never fails, it's just slow. The network connection is fast when copying files etc.

I see nothing out of the ordinary in the event log.

Do any of you have an idea what might be the problem or know how I could try to find the problem?

Thanks!

View Replies View Related

Slow Connection To Sql Server 2005

I have a linked tables from access 2003 to sql server 2005 connected using odbc.

the connection is very slow.

when i use the same linked tables to sql server 2000 the connection is fine.

what seems to be the problem???

View Replies View Related

Slow Connection To SQL 2005 Express

I've just moved a website/database application from windows server 2000 and sql server 2000 to windows server 2003 sp2 and SQL 2005 Express SP2. Database intensive pages now take about 40 seconds where before they took 2-3 seconds.

Things I've tried that haven't helped...

- I changed the ADODB connection string

from: sCnString = "dsn=mydsn;Database=mydatabase;uid=myuid;pwd=mypassword"

to: sCnString = "driver={SQL Native Client};server=myserverSQLEXPRESS;Database=mydatabase;uid=myuid;pwd=mypassword"

- Checked that autoclose is false.

What else can I look at?

View Replies View Related

Sql Server Express Slow Initial Connection

Hi,
I use a Remote Sql Server Express instance, and I have a strange behavior.. The first connection is really slow and I don't know how to fix that.I read some posts about this topic but I didn't find the right solution.Is there a way to "keep alive" the connection between my IIS server and the SQL one ?I check the auto-close property and it sets to false.
Any help ?
Stan

View Replies View Related

Slow Connection To MSDE Named Instance

Hi All

Since I moved our database from an unnamed MSDE to a named instance MSDE, opening a DB connection takes a long time.

The Microsoft Knowledge base article - 273673 discusses this issue and according to it, a database client writes an entry into the registry about the last successful connection:
HKEY_L_MSOFTWAREMicrosoftMSSQLServerClientsup ersocketnetliblastConnect -33423352:lpc:(LOCAL)MYDBS

In case this entry is in the registry, the connection is fast, if the entry isn't there or has wrong info, the connection is slow as mentioned.

According to MS, database clients should write the "lastConnect" entry after a successful connection. Enterprise Manager does it, but an application using ADO.NET does not.
Does anybody have an idea why ADO.NET doesn't do this ?

I could update the registry myself, but I don't know where the number of the entry (-33423352) comes from. It's some sort of hash key, that seams to be machine independent, at least in my domain.
Does anybody have an idea here ?

Thanks a lot for your help!
Best regards, Reto

View Replies View Related

Slow ODBC Connection After Updateing To SQL Server

We have installed SQL 7.0 Client to connect to the SQL server 7.0. After installing the client (which updated all ODBC drivers) the database connections, even ODBC calls using MS access drivers become extremely slow. Any hints where to look?

View Replies View Related

Extremely Slow Client Connection To MSSQL

Hallo

i'm experiencing an extremely slow connection from a WXPP Sp2 client to a MSSQL2000 running on a W2k server. The client is running a VB6 application that connect with Windows authentication: every form requesting data opens with a long delay at the first launch; next attempts run normally fast.

In the same LAN there are some others identical clients, all running fine.

Every other network activity from that client is ok.

Where should i start to investigate from?

View Replies View Related

Access 2007 Connection To SQL 2000 REALLY Slow

I have an Access2000 ADP that I want to run under Access2007.  The problem I have is that some forms take up to 45 seconds to open in Access2007!  These are not complicated forms--just simple navigable reference forms like setting up transaction types etc. that are based on basic select statements like:

SELECT * FROM ArReceivableType

Where ArReceivableType is a reference table (less than 10 columns, all int or nvarchar(100) max) containing about 15 or 20 rows.  They open instantly in Access2000.

I put a trace on to see what is happening on the SQL Server, and I noticed heaps of nasty code like this that generates tens of thousands of reads:

select object_name(sotblfk.id), user_name(sotblfk.uid), object_name(sotblrk.id), user_name(sotblrk.uid) from sysreferences srfk, sysobjects sofk, sysobjects sotblfk, sysobjects sotblrk where srfk.constid = sofk.id and srfk.fkeyid = sotblfk.id and srfk.rkeyid = sotblrk.id and user_name(sofk.uid) = N'dbo' and object_name(sofk.id) = N'FK_FaAssetTransactionWork_ArReceivableType_ArReceivableTypeId'

It looks like Access2007 is reading all of the constraints for the underlying table, including all foreign keys.  My SQL database contains 1400+ tables all with properly constructed foreign keys and other constraints.

Any suggestion on how to NOT have Access2007 do this?  Right now, Access2000 works great for this enterprise app, but I really like the new Access2007 features (and I don't want to still be developing Access2000 apps in 2010).

View Replies View Related

Cannot Set Connection Property Of Backup Database Task If Connection String Is Customized In Connection Object

I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.

Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.

Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.

Is this an intrinsic issue?

View Replies View Related

Enterprise Manager Appears To Slow My Dial Up Connection

I am using a dial up connection to the Internet and to an online SQLServer database.I have a problem in that when I use Enterprise Manager to access evenmy local server , or even, it appears, when it is just open with noconnection to any SQL Server, I experience very slow data transferover my normal dial up connection.I am reasonably sure it is Enterprise Manager causing the problem aswhen I close it and redial I have an acceptable rate of data transferusing my dial up connection.Can anyone:a. support my conclusion that Enterprise Manager is the probablecause of the slow connection.b. suggest a solutionBest wishes, John Morgan

View Replies View Related

SQL Server 2005 Connection Unusually Slow Even Errors.

Hello,I have a Win2K3 Server with SS2005 developers edition. I am working on aWindows XP Pro workstation which has SQL Server 2000 installed as well asthe SQL Native Client. I'm using an MS Access ADP to connect to the serverand for some reason it's extremely slow, even to the point of throwing timeout errors and "can't generate SSPI context" messages. I've hit the MSwebsite and found info on the SSPI error, but none of the items thatgenerate the error apply to my situation. I've tried using the surface areamanager to change the connection to name pipes, name pipes and tcpip etc,but no luck.Is there anything I should be looking at or any known issues that wouldaffect this kind of performance?Thanks!Rick

View Replies View Related

Server Connection From Client Enterprise Manager - Slow

Hi,I am seeing very slow connections from some client enterprise managersto server. Even at server level it takes 1 minute or less to open adatabase. I have adjusted some of the memory for the SQL server, butthere are only about 60 Dbs on the server, totalling about 2 GBs.CPU is very low at all times, 1 GB of ram, p3 1.4Ghz. SQL 2k.I know I should refrag the disk, but is there anything else I can doto speed up SQL operation via enterprise manager--ODBC connections is fairly fast, as well as query analyzer.Adam

View Replies View Related

SLOW Connection To SQL Server 2000 From Enterprise Manager

I have had a problem with Enterprise Manager connecting to SQL Server. At first this problem was experienced with one particular network user... whichever PC he logged onto, Enterprise Manager took ages to connect to SQL Server and every operation was painfully slow. Creating a new Windows NT logon fixed the problem.

I now have this same problem but only on my PC. It doesn't matter which Windows NT logon I use, using Enterprise Manager is painfully slow. I've tried creating a new Windows NT profile, checking the hard drive for errors, defragmenting the disk, reinstalling Enterprise Manager etc but nothing works.

What is strange is that connections from VB applications on my PC are fast. It is only Enterprise Manager that is slow.

I am using the latest service pack for SQL Server.

I thought it could be a problem with the Enterprise Manager registry values but don't want to start messing with them!

Has anyone else experienced this problem? Any advice would be great as I can't find any help from microsoft other than installing the latest service pack for SQL Server.

Thanks

View Replies View Related

Slow Speed When Using Remote Connection In Enterprise Manager

Hi all

I am using enterprise manager for managing my database remotly
in this server there is about 60 Databases when I connect to database and when click on databases folder it take about 30 second to show me all of databases an my database

but some times its very slow and when i click on databases folder it will take about 20 minutes to show databases

whats the problem?

Thanks

View Replies View Related

Slow ADO Connection Speed Vista Vs XP To SQL2005 / Server 2003

I have an application written in VB6 that creates a ADO connection using the (native SQL2005 clien)t from the client to SQLServer 2005 on Server 2003 configured as a stand alone server.  The application works great on XP and has for a number of years.

Now I am attempting to deploy in Vista and using the same code the connection speed CRAWLS.  it's in the magnitude of atleast 10 times slower.  It eventualy works but the selects and doing a readnext against the resulting record set is at a snails pace.

What am I missing.  It's has to be some sort of configuration problem somewhere.

View Replies View Related

Slow Connection Wirt Access 2003 To SQL Server Under Vista

I have an application built with Access 2003 (MDB). It is running under Windows XP without any problems. If I run it under Vista, it works technically well but I get the data very slow from the server.
 
Server:
Windows Server 2003 R2, SP2
SQL Server 2005, version 9.00.3054.00
Firewall: off
 
Client:
Access 2003, SP3
 
Connection strings:
ODBC;DRIVER={SQL Native Client};UID=SD_Admin;DATABASE=SDX;SERVER=MARS;PWD=xxx;
or

ODBC;DRIVER={SQL Native Client};DATABASE=SDX;Trusted_Connection=Yes;SERVER=MARS;
 
Windows Firewall on client: off
Onecare Firewall on client: off
 


 
How can i Fix this issue?

View Replies View Related

Initial Slow Connection To SQL 2K5 On A Windows Server 2003 Machine

Hi,

I'm in the midst of trying to isolate a problem with my application:  Here's the details:

- OS: Windows Server 2003 SP1 (+All security updates)
- DBMS: SQL Server 2005
- ASP web application + COM Components.
- All are located on the same server
- Using basic authentication
-

The application uses an ISAPI filter to grab image thumbnails from the database and send them back to the browser.  If I log into the web app as a machine administrator, the thumbnails are returned quickly.  If I log into the web app as a non-admin, there is a large delay before the thumbnails are returned.  I've run the SQL profiler but it isn't showing me anything useful.
I've used all sorts of combinations for the connection string to the database, and all result in the same behaviour (Using different providers, etc.)

The funny thing is that the initial get of thumbnails takes a long time, but any subsequent runs results in the images returning immediately.   If I restart IIS then the problem comes back.

Any thoughts on why an admin account would be fast and a non-admin slow?  

Best Regards,
Greg.

ps.  I hope this is in the right thread.

View Replies View Related

Slow Connection. ASP Page Querying A Linked Server On MSSQL 2005

Creating a web application.  Running a simple query "SELECT username FROM vwCustomer"

vwCustomer is a view built on top of an Access DB which is set up as a linked server.  Within SQL Server that view responds immediately.  But when I try to access it from an ASP page it takes over 20 seconds to respond.

Used the following to create the linked server:

EXEC sp_addlinkedserver 'DBName', 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'c:databasesdatabase.mdb'

GO

EXEC sp_addlinkedsrvlogin 'DBName', FALSE, NULL, 'Admin', ''

GO

The view is simply(this works fine in SQL Server):

SELECT * FROM DBName.db.dbo.customer

The ASP page:

SELECT * FROM vwCustomer

Can anyone give me a hint as to where the bottleneck is?  Or how I can figure that out using SQL Profiler or something?

Please help!

View Replies View Related

Very, Very Slow Database - Mystified

We just installed SQL Server version 800.194 on a dual processorserver equipped with a gigabyte of RAM, running Windows 2000 Serveroperating system. We set up a few databases with (so far) very tinytables.When I am working locally (i.e. on the server itself) with QueryAnalyzer, even the simplest operation is incredibly slow. If I bringup Windows Task Manager looking at the Processes pane (Query Analyzershows up as "isqlw.exe"), and use "View/Select Columns..." to choose"I/O Writes" and "I/O Write Bytes", then I observe that doing aselect* on a table with a single row results in over 500 "I/O Writes"and 170,000 "I/O Write Bytes" of data written. It requires 15 secondsto return the single row of information.Even clicking on the Change Database Listbox results in hundreds ofwrite operations!However, when I am working remotely with Query Analyzer, the select*works perfectly normally. Neither "I/O Writes" nor "I/O Write Bytes"are recorded.I figure maybe there is some sort of security logging turned on thatrecords everything you do...Whatever is going on here, how do you turn it off?Tom

View Replies View Related

Database Sql Server2000 Very Slow

I have a database that had worked under msde 1.0 until reached the 2GBof dimension and the dB was blocked. To make possible the work i haddeleted old data from some table. The database restart, but theanswers from server become very slow. So i decided to pass to SqlServer 2000 without success. May i perform a check of this database?if is a indexs problem there is a way to rebuild them?Thanks in advanceAndy Wet

View Replies View Related

Run Access Database Too Slow

I have a access database, the data store in another server. This noon, one of our user is runing the access database too slow. Open the database and search the data, etc. It took a long time to come out, Any body has experience on it, why, we had etrust install on each user machine, is that cause this too slow? Thanks in advance.

View Replies View Related







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