sql server odbc: How to improve CPU Time -- sql server odbc

How to improve CPU Time

vijay
4/7/2005 5:42:36 PM

sql server odbc: Platform: Win2000, VC7, MFC, ODBC

Hi,

I have developed a server application which runs 24x7. Backend database is
SQL Server. Application inserts data in the SQL Server database using ODBC
connection. Let Application runs on machine (M1) and SQL Server is running
on machine (M2). After 13:30 hours of testing, reading of both machines is
given as below

Machine | No of hrs | Idle time | CPU Time

----------------------------------------------------------------

M1 (App.) | 13:30 | 13:14 | 0:16

M2 (SQL) | 13:30 | 02:15 | 11:20

Time taken by SQL Server machine is so much. Could any one suggest

1. How can I decrease the CPU time of MSQL Server machine?

Regards

Vijay

Re: How to improve CPU Time

Mike Epprecht (SQL MVP)
4/7/2005 7:24:52 PM

Hi

Is your database tuned? www.sql-server-performance.com will give you tips on
what to look for.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]