You are here: Re: 100 % CPU Usage « MsSQL Server « IT news, forums, messages
Re: 100 % CPU Usage

Posted by Erland Sommarskog on 11/26/05 13:04

Paul (paulwragg2323@hotmail.com) writes:
> I got the MDF and LDF files from the customer and the same thing
> happens, so it doesn't appear to be anything that happened during the
> backup/restore process.

Just to refresh my memory: the effect does not happen at the customer's
site, only when you try it on your machines in-house?

Indeed very strange. What difference could there be between your customer's
configuration and your own? Yes, I know that you tried it on three different
machines in-house, but I suspect they may have something in common, which
they don't share with the customer's machine. For instance, the customer
may be running on a cluster, but you don't? Operating system? Exact SQL
Server version? And not the least, the version of MSVCRT.DLL?

And, another check, what about anti-virus?

> So I am still at a loss and I do not want to pay for support from
> Microsoft if this is not a bug. I think we have somebody in the company
> who is an MSDN subscriber though so I will try and get round to raising
> this if I can (and I will post back).

I will have to admit that at this point I would probably be prepared to
pay to find out, just to ease my own curiousness. It's just so damn weird.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация