Help please. SQL 2005 express sp1, sqlservr.exe high CPU usage

Question

Help please. SQL 2005 express sp1, sqlservr.exe high CPU usage

Viewing 5 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

That's your first error. Sql dbs are live and can't be copied into any image software I know (except expansive san ones).

If you had screwed up the db could have been gone for good.

At the very least take a native backup in sql server and play with a copy of the db... no harm if you screw it up there.

aaapppleee SSC Journeyman Points: 82 More actions · Answer 2

Thank you for your reply.

He is my best friend, he just wish me try it for him.

so I have to:cool:

I have native backup for it.

If I turn off the computer and do the disk image, how about the database, is it ok?

I will use acronis, how about san ones?

LutzM SSC Guru Points: 107049 More actions · Answer 3

~~Even if~~ Because of he's your best friend you should not jeopardize his business software. Friendship is a personal relationship. Changing software his business might rely on is purely a business issue where a related skill set should come into play, not friendship.

Ask him a very simple question: Will he still be your best friend if the steps you try might lead to a totally unusable software together with a complete loss of data? If the answer is "yes", then you could give it a try. Otherwise, don't put that friendship at risk. Nor his business.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

aaapppleee SSC Journeyman Points: 82 More actions · Answer 4

Good,

I won't do it then. I will ring him let him know.

ok, I will play it on my own spare computer.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

Did you see the following?

Are you prepared for SQL Server performance problems?

Read Holger Schmeling's free "SQL Server Statistics" eBook to brush up on your statistics and query-optimization knowledge, and monitor your SQL Servers whenever, wherever with new SQL Monitor.

http://www.red-gate.com/products/dba/sql-monitor/entrypage/holgerschmeling-ebook?utm_source=dbw&utm_medium=email&utm_content=holger_schmeling2_20110515&utm_campaign=sqlmonitor

Download your free resources now.

http://www.red-gate.com/products/dba/sql-monitor/entrypage/holgerschmeling-ebook2

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/