Sedang Disiapkan

SQL issues (CPU running at 100% all the time)

We need some help to figure out what is causing SQL to cause 100% CPU use.

Either we have increased the amount of user traffic and need more CPU which is not likely the case since December is a low traffic month for us.

Or we have script(s) with poorly-optimized SQL queries that are not scaling well with user traffic.

Even after restarting the server it goes to 100% right away.

We need help to figure this out.

Thanks.

The Server is Windows and the website is written in classic ASP.

Kemahiran: ASP, SQL

Lihat lebih lanjut: sql running 100 time, what month is december, need sql help, the time, sql queries, Sql 2012, cpu 100, queries sql, cpu time, sql traffic, time running, running total reverse sql, access issues sql odbc, help sql queries, running total days sql, design devloped time attendance system vbnet sql server, running automatic backups sql express 2005, simple running total count sql view, time estimate convert access sql, issues sql 2008, running sum total sql update

Tentang Majikan:
( 43 ulasan ) Mississauga, Canada

ID Projek: #4032866

Dianugerahkan kepada:

deescorp

I am expert in SQL Server Database Optimization. I did this work many times for different systems.

$250 USD dalam sehari
(3 Ulasan)
3.3

3 pekerja bebas membida secara purata $150 untuk pekerjaan ini

barundebnath

Is it a windows based server ?

$100 USD dalam sehari
(10 Ulasan)
4.4
vladang

Hello sir. I am interested for your job. Please, send me more info Regards vladang

$100 USD dalam 5 hari
(3 Ulasan)
2.4