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.
| Author |
Topic |
|
suchiate
Starting Member
33 Posts |
 Posted - 2007-04-29 : 09:03:12
|
| Hi All,Recently I just took up another application administration from my company but this application seemed to have database handled pretty badly.It is a queueing system whereby it can reach 1000 - 3000 concurrent and multiple response and requests at the same time. But I am not sure whether it is the database that is causing most of the problems because i see active connections ranging from 90-200 and most of them are under object locks which I am not familiar with.And im getting server unavailable 503 at my applications after stressing it for a while and I must stop those applications or recycle the application pools i created for them in IIS.I am not sure whether its the machine that cannot handle, or theres too many database connections causing timeouts?Can somebody help me out on this? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-04-29 : 10:36:47
|
| how many db accesses do you have per page?if you have just 1 and you have 3000 pageloads per second that would mean 3000 db accesses per second which is a lot.this would mean that you'd have to have a good hardware, maybe a cluster...give us more info about your system._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
suchiate
Starting Member
33 Posts |
Posted - 2007-04-29 : 10:47:42
|
| its a Pentium 4 2.8, 2.79 GHz Dual Core running on 1GB RAMBelow is the flow of the applications:1. MainApplication receive > Post to respective page2. Page Response to MainApplication and Post to Third party3. Third party receives and returns to Page4. Page post to MainApplicationI am yet to fully go through the codes because there are too many levels and I just took over the application recently. But it seemed to me that there are too many tiers going through and if database connections have not been closed properly or locked then it might be a problem.But I am not sure whether it's the hardware or the database locks leading to timeouts.. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-04-29 : 10:53:45
|
| run profiler trace for a while to see what kind of traffic do you have on the databse.that way you'll be able to find out if the db is the bottleneck_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
suchiate
Starting Member
33 Posts |
Posted - 2007-04-29 : 11:01:33
|
| How may I be able to run the profiler trace? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-04-29 : 11:08:46
|
| Profiler is an application that comes with sql server client tools.like SQL Server management studio_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
suchiate
Starting Member
33 Posts |
Posted - 2007-04-29 : 11:14:32
|
Alright, thanks alot for your help, I will try it on the next run time of the application.Really appreciate it.If you dont mind, can i come back to you with the stack trace after running the profiler?  |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-04-29 : 11:34:08
|
| just post it here._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
Database Locks