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
- Check out this weeks #scala news blog: http://t.co/mqKyRQzf 7 hours ago
- Slides, sources, video and much more from Jan's talk last night at http://t.co/0qhWU9lX #Scala #lsug /cc @skillsmatter @honzam399 1 day ago
- #springframework and #Scala's Cake pattern: http://t.co/RVRzcQb4…. More tomorrow evening at @skillsmatter! 3 days ago
- Christmas tree that keeps coming back. Let me dispose of it in an environmentally-friendly way at http://t.co/GJsoPhjk #Scala #complexity 3 days ago
- I just uploaded "Cake Solutions Testimonial from Norman Niven - Protomed Managing Dirctor" on Vimeo: http://t.co/7FvHrSAH 4 days ago
Archive
Categories
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