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
Solved

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

Posted on 2013-01-30
6
451 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
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…

839 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