Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2013-01-30
6
Medium Priority
?
472 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 
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 2000 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this article, we’ll look at how to deploy ProxySQL.
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…

715 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