Solved

sql database server very slow, pages/sec very high

Posted on 2013-05-28
6
362 Views
Last Modified: 2013-06-23
We run 3 virtual servers running windows server 2008 on our hp server that runs xenserver 5.6.   All workstations are actually on a workgroup but we run active directory on same vm as sql.  Application server on 2nd vm. 3rd vm is the terminal server.
We run one application in that rdp session.  We have 2 cisco small business smart switch one 48port and one 50 port with poe.  I have reset both configs.  We have Avg business 2013 installed and have it on every vm, saying up to date and no infections. We are having random freezing or slowness but all rdp sessions stay connected.

 After i have done some performance monitor on our sql server, that seems to be the issue. it has pages/sec as high as 1100.  we have about 50 computers rdp into the ts then they open the application that pulls from the sql server.  
the picture i took was off hours, i will be taking one during hours. the virtual machine has 40gb of memory and 33gb sql keeps taking from the system. the page file is around 35gb and everyone is complaining about slowness.  what can i do to improve this?
counters.gif
0
Comment
Question by:bowlerman25
  • 4
  • 2
6 Comments
 
LVL 4

Expert Comment

by:rlog
ID: 39203730
You can constrain the amount of memory SQL Server takes. Look in properties on the sql server object and select memory from the left meny. Set Maximum server memory to 16384 mb (16x1024mb) as a start.

In case it's not SQL that grabs the memory you should monitor which process consumes most memory. I have seen sql server doing very little but grabs lots of memory.

SQL Server often grabs as much memory as can and doesn't release it until the server needs it "badly".

All workstations are actually on a workgroup but we run active directory on same vm as sql.
This is NOT recommended.
0
 

Author Comment

by:bowlerman25
ID: 39205489
why is "All workstations are actually on a workgroup but we run active directory on same vm as sql.
This is NOT recommended. "

why is this not recommended? i have this setup at a couple places and it works great.

also with all users on the server up 3000pages/sec for memory, page faults as high at 6000-10000 but mostly around 3000 or less. processor interrupts are as high as 12000. are any of these an issue?  do i need to post different counters so someone can help?
0
 
LVL 4

Expert Comment

by:rlog
ID: 39205937
Read this

SQL has a habit of sucking up lots of memory and when running combined with a dc lots of stuff happends when memory is in shortage. Not sure if you've experience this in terminal servers?

Did you constrain max memory setting btw?
0
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.

 

Author Comment

by:bowlerman25
ID: 39209536
can you tell me where exactly it is to limit the memory?

To improve performance i was thinking about doing this. also we are running sql and AD on same vm. I will make the 2nd vm be a dc then i read i have to uninstall sql then demote the original dc then reinstall sql? is that correct?
0
 

Accepted Solution

by:
bowlerman25 earned 0 total points
ID: 39257897
the whole problem is not solved but i think i know what it is. i call citrix and got support, they made me change the management nic to a different nic then the traffic nic, somehow is makes a difference.
0
 

Author Closing Comment

by:bowlerman25
ID: 39269115
both answers are good, we did not solve issue yet
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…

911 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

24 Experts available now in Live!

Get 1:1 Help Now