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

Posted by Paul on 10/01/89 11:39

It turns out that we have a table that is over 1GB in size. We only had
the server configured to allow SQL Server to use 800MB.

Therefore, when we were querying using a query resulting in a full
table scan there was not enough memory to perform the query. Instead of
returning an error it basically just stopped (or maybe it was doing the
query but it would take years!).

Anyway, thanks to all those that posted!

Paul

 

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

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