Solved

SQL Server issues and troubleshooting

Posted on 2012-04-12
4
356 Views
Last Modified: 2012-07-02
Hi,

I am looking for some advise on SQL Server troubleshooting....

Basically I have SQL Server 2005 on a windows 2003 server. We have a customised program which is developed in .NET and uses .NET framework on this server. We also have 3 other SQL database servers on this server.

The issue is that the server is peaking at 100% CPU usage intermittantley. I get an alert from VMware and the applciation itself often displays a timeout error, however it does not indicate what request caused the timeout. I know its within the SQL database but how do i find out which application or which specific request is causing it to peak?

I need to be able to determine which transaction and system is causing the SQL Server to peak at 100%.

Also, what are the limitations on running several SQL databases on one Server? We have 4 different databases, 3 of the applications are on the server and the fourth application is on a seperate server.
0
Comment
Question by:collie3
[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
4 Comments
 
LVL 19

Expert Comment

by:Zaheer Iqbal
ID: 37838011
Did you say the .Net Applications are installed on the SQL Server also, if so I would move them off to another server and only keep the Server as dedicated SQL Server
0
 

Author Comment

by:collie3
ID: 37838128
I can do this but I really need to find out what is causing the server to peak first. The applciation has always been slow and cumbersome and is still being developed, however it is IT against the company that are developing it. So i really need to get down to the detail of what transaction or app caused the server CPU to peak.
0
 
LVL 19

Expert Comment

by:Zaheer Iqbal
ID: 37838196
Have any .Net updates been installed on the Server ?
0
 
LVL 19

Accepted Solution

by:
Zaheer Iqbal earned 500 total points
ID: 37838231
0

Featured Post

Simple, centralized multimedia control

Watch and learn to see how ATEN provided an easy and effective way for three jointly-owned pubs to control the 60 televisions located across their three venues utilizing the ATEN Control System, Modular Matrix Switch and HDBaseT extenders.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
2-Factor authentication VPN for staff and suppliers 6 90
SSH setup on ASA 5505 17 120
sonicwall vpn green lights on both, but no traffic 10 55
Applying Roles in Common Scenarios 3 43
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Secure VPN Connection terminated locally by the Client.  Reason 442: Failed to enable Virtual Adapter. If you receive this error on Windows 8 or Windows 8.1 while trying to connect with the Cisco VPN Client then the solution is a simple registry f…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

737 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