| Angus Logan [MVP] 2004-12-22, 7:46 am |
| Hi All,
I just had a really bizzare issue with MCMS & SQL.
Environment
- WinXP + MCMS Developer Edition
- Win2k3 + SQL Std Edition
When I chose to compare 2 revisions of a posting ; and one of the revisions
was after a certain date (I guess I changed the template after that date)
the page would freeze; I did an iisreset etc. and this didn't resolve the
issue.
I then noticed the SQL Server was at 100% CPU.
Once I rebooted the SQL Server the revision comparer worked perfectly...
I didn't have time to profile the database so I couldn't check for locks.
I have never experienced this before but it was plenty strange...Any ideas?
--
________________________________________
Angus Logan (MCAD/MCDBA/MCP/MVP for MCMS)
Product Specialist
Microsoft Application Solutions
Data#3 Limited
E angus_logan@data3.com.au
BLOG www.anguslogan.com
________________________________________
|