I have come across a strange behaviour in 32bit MS SQL Server 2005 running on 64bit Windows Server 2003. During a query execution, the SQL Server started using 100 % of one CPU and got stuck at
ntoskrnl.exe!IoIs32bitProcess+0x45
ntoskrnl.exe!FsRtlAddBaseMcbEntry+0xa2
...
The query was — perhaps inefficiently — using a view that selected rows from a table that was also used in the select statement. To illustrate, the query’s structure was this:
select
*
from
Table1 t1 inner join
Table2 t2 on t1.table1 = t2.id inner join
View1 v on v.table1 = t2.id
...
where the view View was selecting rows from Table2 and (some other) Table3.
Removing the view fixed the problem and SQL server executed the query without any problems. It could all be a coincidence, but if you ever get to this situation, check your views.
Websites
Search
Follow us on Twitter
- Cake Solutions - January 2012 Newsletter #constantcontact http://t.co/kG8mdRTC 21 hours ago
- Why we come to work at Cake: http://t.co/K3f2HNan 1 day ago
- #Specs2Spring 0.4 is out with support for #springframework 2.5-3.1, #hibernate 4 and many other improvements. http://t.co/io3NPEZn… #Scala 2 days ago
- Cake's January Newsletter - Oxford Office, Outtake video and much more.... http://t.co/OlZddnNJ 3 days ago
- I just uploaded "Cake the Movie - Outtakes" on Vimeo: http://t.co/2rQOvo3w 3 days ago
Archive
Cake Solutions
agile AJAX Akka Cake pattern Cloud dm Server Haskell intellij intellij idea iPhone java Java EE Javascript jQuery lift mongodb open source central Open Spring 3 OSGi Play Programmers' humour Projects racing rails ruby ruby on rails sbt Scala Scalad scala ide Scalaz Specs2 Specs2 Spring Specs2 Spring Web Spring Spring 3 Spring 3.0 Spring Framework spring mvc springsource Spring User Group SUG Talk training zookeeper-
Recent Posts