| Stefan [MSFT] 2004-12-22, 7:46 am |
| Hi Angus,
this problem has never been reported before.
Sounds like a temporary problem with the SQL server.
If it reoccurs, please run a profiler trace.
Cheers,
Stefan.
"Angus Logan [MVP]" <angus_logan@data3.com.au> wrote in message
news:eM3kLEB6EHA.4072@TK2MSFTNGP10.phx.gbl...
> 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
> ________________________________________
>
>
|