web is slow due to sql error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

web is slow due to sql error

Author

Topic

meenus
Starting Member

10 Posts

Posted - 2011-10-26 : 17:55:30

Dear friends,
I am in a big trouble .Pls help me.It is very urgent.
My server sql version is as follows

Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services Client Tools 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3615
Operating System 5.2.3790

my servr specification is as follows

Server 2003 std edition.SP2
intel(R) core(TM)2Duo CPU
E6750 @ 2.66 GHz
2.67 GHz, 1.99 GB of RAM
physical address extension

I am a programmer.Now i am facing some server problems due to the absence of server administrator.

let me describe my problem

I developed a website and hosted in godaddy dedicated server.
website speed was fine till last week.But now a days we are getting timeout error some times when we are trying to access the website.The error i quoted below.

one of my main table in database contains 427657 rows .and daily nearly 8000 rows are adding in to this same table using a socket application in server.the amount of data transfer was very less 2 weeks back.That time website was working fine without any problems.But now data tranfer to sql is very high and website is very slow.How can i solve this issue.Pls pls help me.......

website is slow from the home page itself.In home page we are just connecting with sql .That time we are getting error as follows.

quote:

SQL Exception
Error Details
File
Error Index #: 0
Source: .Net SqlClient Data Provider
Class: 11
Number: -2
Procedure:
Message: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.AddLog(String LogGUID, String LogTypeKey, Int32 LogUserID, String LogUserName, Int32 LogPortalID, String LogPortalName, DateTime LogCreateDate, String LogServerName, String LogProperties, Int32 LogConfigID) at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.WriteLog(LogQueueItem objLogQueueItem)

quote:

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2011-10-26 : 18:19:27

Try increasing the default command timeout, or check that the server actually is running.

N 56°04'39.26"
E 12°55'05.63"

Sachin.Nand

2937 Posts

Posted - 2011-10-27 : 01:17:53

2 GB is not a good memory to go with.My laptop has 4 GB of RAM and still I feel its less :)

You urgently need to add more memory with 8000 rows being added each day you are taking really a big risk with just 2 GB of RAM.

Between is your server 32 bit or 64 bit ?

PBUH

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2011-10-27 : 04:08:06

8000 records each day is an average of one record every 10-11 seconds. I can do that manually.
2GB is quite sufficient for this.

N 56°04'39.26"
E 12°55'05.63"

Sachin.Nand

2937 Posts

Posted - 2011-10-27 : 09:24:11

And what about the 427657 rows that already exist and not even considering the rows from the other tables ?

And sql server is not going to get all of the 2 GB.1 GB will be used by OS and sql will only get the other 1 GB.And OP did mention that he has PAE so its possible that he can get up to 64 GB of memory accessed if his system is 32 bit.

PBUH

X002548
Not Just a Number

15586 Posts

Posted - 2011-10-27 : 09:34:54

First, that's not a lot of data

Second, how much data are thry trying to drag to the web app...everything??? I've seen (moron) developers try to do this

Second, is the data properly indexed?

We need to see the table DDL, including Indexes and the SQL statement..OH, are you not using stored procedures???

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

meenus
Starting Member

10 Posts

Posted - 2011-10-27 : 13:48:45

Dear friend,I think you said is rgt.So i am going to increase RAM from 2 GB to 8 GB.Is it enough for this?Our server machine is 32 bit.

quote:
Originally posted by Sachin.Nand

2 GB is not a good memory to go with.My laptop has 4 GB of RAM and still I feel its less :)

You urgently need to add more memory with 8000 rows being added each day you are taking really a big risk with just 2 GB of RAM.

Between is your server 32 bit or 64 bit ?

PBUH

meenus
Starting Member

10 Posts

Posted - 2011-10-27 : 13:57:04

dear friend,
we have GPS vehicle tracking system.

Our server having a socket application.Which is receiving 150 vehicles location details in each 1 minute interval.And pushing this data to SQL.This socket application is recving data and pushing data to SQL continusly.In addition all website files are also occus in this server.Lot of peoples are accessing the website same time.

our server is configd with 10 mbps transfer rate.

now i am planning to increase this to 100mbps .
Ram will increase 2 GB to 8 GB.

whether it will solve my issue or not?

I am a programmer so i dont know the server configuration details.So pls help meeee
'

thanks a a lot

quote:
Originally posted by Sachin.Nand

And what about the 427657 rows that already exist and not even considering the rows from the other tables ?

And sql server is not going to get all of the 2 GB.1 GB will be used by OS and sql will only get the other 1 GB.And OP did mention that he has PAE so its possible that he can get up to 64 GB of memory accessed if his system is 32 bit.

PBUH

Sachin.Nand

2937 Posts

Posted - 2011-10-27 : 14:23:19

For your current scenario Upto some extent YES.You did say that PAE is enabled on the server. Right ???Now you might want to set AWE(google for it) and set the minimum and maximum memory for sql server.

Now comes the query part.You need to post the query where your time outs are occurring.

PBUH

Sachin.Nand

2937 Posts

Posted - 2011-10-27 : 14:40:05

Oh is your server edition standard ? To bad it wont support more than 4GB of physical memory.The best you could do is set a /3GB switch.So SQL server can use upto 3GB and keep the rest for the OS.

PBUH

meenus
Starting Member

10 Posts

Posted - 2011-10-28 : 01:15:30

un fortunately goaddy people telling it is not possible to add RAM in dedicated server according to thre rule...they are telling to hire a new server

quote:
Originally posted by Sachin.Nand

Oh is your server edition standard ? To bad it wont support more than 4GB of physical memory.The best you could do is set a /3GB switch.So SQL server can use upto 3GB and keep the rest for the OS.

PBUH

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources