Question Locked

Microsoft CRM runs very slow after 6:00pm

0 helpful
28 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all,
Please help me to find a reason for the problem with CRM on my server. I am using 2 servers for CRM (01 Application server, 01 Database Server)
- App server is included Citrix, CRM application.
- Database server is included SQL Server.
I don't know why everyday after 6:00 it runs very slow even no response. I tried to scan viruses, monitor to find is there any strange process but totally useless.
Kindly help me to find out the problem!
Regards,
Khoa

28 replies

by cmiller5400

Well, what runs at 6:00 that could cause interference? Backups? Database maintenance?

by ledinhkhoa

There is no program to be schedule for running at 6:00pm. Especially it only occurs from 6:00pm to 7:00pm everyday.
At the time, I monitored the AVG Disk Queue Length, it was around over 50.
Could you give me some ideas for fixing the problem.
Thanks,
Khoa

by older mycroft

System backup in a Print Company that I'd previously been a Production Manager in, years before. The backup was failing every Tuesday & Friday night - but NEVER failing on a Monday or Wednesday night (they didn't run a backup on a Thursday because it was late opening until 21.30).

Eventually I went in on one of these offending nights and sat watching the backup from a discreet distance: one by one the staff numbers dwindled and eventually I was sitting there in the Costing/Estimating Department on my own, snoozing to the hum of the network.

Then the hum stopped! Just as the office cleaner unplugged the main server to plug his vacuum cleaner in!! :^0

Needless to say, the Company were saving money by only employing the services of office cleaners on Tuesdays and Fridays. ;)

by oh smeg

That during winter used to go off at 6.00 AM every Sunday Morning. The Key holder had to be called in and open the place so that the Police could check it out. Needless to say it got tiresome and what was worse I was given the Job of being the Key Holder to encourage me to fix the problem as the Company who supplied the Alarm System had passed it 100% correct on numerous occasions.

Of course I was only given the job after the problem stopped for the summer so I had no issues with it till next winter. And naturally again there was nothing wrong with the system when the alarm started going off. After 3 weeks of this I bit the bullet and stayed in the building and sure enough the Alarm started at 6.00 AM. Only took 3 weeks to find the problem which was a PIR Sensor way up near the front of the warehouse every Sunday morning a Truck would drive past from the Newspaper Publishing place up the road and sunlight would reflect off it onto the PIR Sensor causing the Alarm to trigger. Earlier or latter in the year the sun was in the wrong position to cause the reflection which triggered the alarm so it was a hard one to track down but an easy fix when it was known what was going on.

Col

by ledinhkhoa

I have installed the program and captured the packages. I found that no thing strange.

by oh smeg

But it was hard dealing with the Company who supplied it as they wouldn't accept that there was a problem. Of course they did decline my offer to make the CEO the Key Holder so he was the one getting out of Bed early every Sunday Morning in Winter. :^0

Col

by rob miners

checked the Event Logs for any discrepencies at these times. You could also open Task Manager and check on the Processes and Services. What was the result from WireShark.

by ledinhkhoa

Dear Jacky,
I have check in the event logs, Task manager, they are in normal status. When I check in the performance monitor, the AVG Disk Queue Length is very high (over 50). I really don't know why? This problem always occurs everyday around 6:00pm to 7:00pm.
I have setup WireShark, it seems nothing be strange on the database server.

by rob miners

updating or scanning. You may have to reschedule it to do this at a more appropriate time.

by ledinhkhoa

Dear Jacky,
No, I don't use AVG antivirus. AVG Disk Queue Length is an information of MS Windows, I got it by using peformance monitor feature of windows (Control Panel -> Administrative Tools -> Performance -> click on System Monitor). You will see AVG. Disk Queue Length variable. This one is very high from 6:00pm to 7:00pm.
Regards,

by oh smeg

Now what you have to do is find out what is running and causing it to slow down.

The Obvious thing would be it's event Logs and you need to look at things actually running then not for something strange. You could have a Normal Service running at the wrong time consuming System Resources and slowing things down considerably.

Col

by ledinhkhoa

I have check many programs, sevices, there is no program or service to be schedule at the time. At the time the system was slow, I found that sqlservr.exe running and get around 5% CPU continuously.

by ledinhkhoa

I don't think the problem is form Office Cleaners. Because my server is in my room, and nobody can open the room at the time.
Regards,

by ledinhkhoa

Base on your information, I monitor the process and found that the problem comes with SQL Server at exactly 6:12PM. Anybody, please contribute your opinions to help me to solve the problem.
Thanks,

by oh smeg

What does the Task Manager show here as well?

Col

by shellbot

Check to see whats being processed by SQL at that time especially:

-backups being taken
-jobs being run

How did you find out the time of 6:12 pm?
If its a set time each day, good chance its soemthing which is running as its been set to run. Are there any external items happening at that time..for instance:
- data imports / exports
- system backups

by ledinhkhoa

- I used performance tools (Start--> Control Panel --> Administrative Tools --> Performance) to monitor the Average Disk Queue Length. It was very high at the time (6:12pm).
- There was no SQL job run at the time
- The was no backup to be run at the time also (I have checked Windows System and SQL also). All backups I have set them to be run at midnight.

by cg it

My AV runs at 6pm which is the default for it.

At that time, SQL runs very slowly and if you have an application that queries the DB on SQL, it will run "very" slowly or become no responsive.

by shellbot

Do you know if anything is being run by your IT team at that time?
For example, the place I am in uses a software package to do backups of the servers. This package is not run on the server that has SQL, so you can't see it on that box.. its run through the network and it can cause performance issues occasionally.

This discussion is closed to new replies.