Solved

2008 64 bit msql server running slow until we restart the service

Posted on 2013-01-30
6
424 Views
Last Modified: 2013-02-05
This problem arrises about once every 3 days.  We have on average about 125 users running an application that connects to 64 bit microsoft sql.  the server has 24 gig of memory and 16 gig is allocated to the application.  The developer says that 10 gig of mem to sql is more than enough.  the users run a remote desktop environment between 8 terminal servers.  all users slow down dramatically at about the same time.  There seems to be nothing wrong with the server.  no memory utitlization increase.  no spikes in cpu.  the select statements in real time monitor seem to snap along.  also some of the other applications running on the users session will seem to slow at the same time.   outlook for example.  when we restart the sql service all problems clear up.  users are fine for a few days.  until it arrises again.  we are scratching our heads.

8 terminal servers hosting 200 sessions.
all slow at the same time.  especially the app running on the sql server.
restart the service associated with that instance of sql server and everything speeds up.
please help
0
Comment
Question by:jamesmetcalf74
  • 3
  • 3
6 Comments
 
LVL 39

Expert Comment

by:Kyle Abrahams
Comment Utility
any jobs running on the sql server?  Could be memory leaks in the application? (yes, even in .Net memory leaks still exist).

Could be a long running transaction and or databaselocks on the server itself.
0
 

Author Comment

by:jamesmetcalf74
Comment Utility
no jobs that i know of
how can i find if their are memory leaks on the application.... the application runs slow across 200 users.... on 8 different machines. all at the same time.
we have decided the problem is some sortof connection with the sql database...
or the database itself but it looks fine under our eyes
we do not have a dba on staff
0
 

Author Comment

by:jamesmetcalf74
Comment Utility
how can i check for database locks or a transaction that is hanging around?
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 39

Expert Comment

by:Kyle Abrahams
Comment Utility
0
 

Author Comment

by:jamesmetcalf74
Comment Utility
are locks common... i guess what im wondering is...
after i see the locks displayed.... how can i tell if that is bad or good.
or are all locks bad?
0
 
LVL 39

Accepted Solution

by:
Kyle Abrahams earned 500 total points
Comment Utility
Locks are somewhat common.

I would double check the wait time
with this one:
select cmd,* from sys.sysprocesses
where blocked > 0

If you see that increasing you have a locking problem which the developer can isolate for you.

A good article about locking (grab a cup of coffee or something):
http://www.methodsandtools.com/archive/archive.php?id=83

Essentially locks block other users from using the same row/table while a user is working with it.  They are necessary, but if managed improperly, can wreak havoc.

Again, without knowing the full architecture of the application, it's impossible to know, but I know locking is one of the usual suspects.

You mentioned you have a developer . . . is it possible for him to troubleshoot?
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
Read about achieving the basic levels of HRIS security in the workplace.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now