[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 360
  • Last Modified:

SQL Server issues and troubleshooting

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
collie3
Asked:
collie3
  • 3
1 Solution
 
Zaheer IqbalTechnical Assurance & ImplementationCommented:
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
 
collie3Author Commented:
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
 
Zaheer IqbalTechnical Assurance & ImplementationCommented:
Have any .Net updates been installed on the Server ?
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now