MS SQL Server ODBC - How to improve CPU Time

Author

How to improve CPU Time

vijay

2005-04-07, 7:01 am

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

Mike Epprecht \(SQL MVP\)

2005-04-07, 8:01 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/

"vijay" < vijaysingh@abosoftwa
re.com> wrote in message
news:uZGX3r2OFHA.2356@TK2MSFTNGP14.phx.gbl...
> 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
>
>
>
>

Sponsored Links