The forums in this section of DUG are no longer accepting new post, but you can still get lots of value from the old posts here. Please visit the active forums to comment/post new questions (choose which product you are interested in):
You might have noticed it. But the last 2 hours something has been wrong here! The website has slowed down! Not a little but a lot!
On the server I can see that my SQL Server (sqlserv.exe) suddenly is using almost 100% of my CPU.
What can I do to check exactly what's wrong? I've tried to reboot a few times but it's just the same when it comes back again.
The activity monitor with SQL doesn't give me much information.
Have a great day, Erik
For me its approx 4 hours when page loads 2-3 minutes, I decided Latvian GIX was experiencing foreign traffic problems, but ping = 120ms, that is OK
Erik, what exactly you changed - that started as soon as you redesigned the look & feel of site. Maybe SQL overload is caused by some of the changes? I don't know CS etc, its my guess only.
MCP-Dynamics NAV Application
In reply to Modris Ivans:
Well, now its OK again - but only 10 mins ago it was still sloooow
Yes I see it too. Just rebooted once again.
Nothing has changed on the the server. That I know of! But you know how that is!
In reply to Erik P. Ernst:
use admin tool to monitor to check, also use SQL profile to have a look at the transactions