I have windows 2003 server with SQL Server installed on it for live calls billing but the CPU utilization is reaching the maximam and it's average above 60% which is causing lot of problems specially for the live environment. I have enough memory and free hard disk space is more than 40GB,
so where is the problem?!
Have you run done any performance analysis? Is SQL Server the only application running on the server? Have you looked for any long running queries that might cause the problem? Have you look for blocks and locking issues? Have you kept the server and SQL Server up to date will all Service Packs, and patches? You need to provide a little more information to get any kind of usefull answer to your question.Brad Feaker
|||
the problem solved.
There ware triggers running every second on the server
No comments:
Post a Comment