Solved

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

Posted on 2013-01-30
6
460 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 40

Expert Comment

by:Kyle Abrahams
ID: 38836982
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
ID: 38836996
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
ID: 38837035
how can i check for database locks or a transaction that is hanging around?
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 40

Expert Comment

by:Kyle Abrahams
ID: 38837161
0
 

Author Comment

by:jamesmetcalf74
ID: 38837215
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 40

Accepted Solution

by:
Kyle Abrahams earned 500 total points
ID: 38837256
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
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…

713 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