Share
Report
5,985Hi All,
A colleague of mine was just viewing the item history (Inquiry--Inventory--Item Transaction) when their GP client became unresponsive. They mentioned the slowness to me and when I pulled up the resource usage for the SQL server I noticed that the CPU was pegged at 100%. Has anyone one else come across this before? I am pretty sure the answer is to just use another reporting method but I was curious if this behavior is pretty common when you are viewing items with a ton of history.
The client remained responsive and the server load stable right up until we tabbed out of the the end date restriction field at which point the client froze up and CPU usage on the server spiked. The date range we used was about a week. As background the item we were looking at is a catalog that is tracked as a line item for almost every sales transaction we process in GP. I can't recall offhand but I believe we have about 6 years of historical data in the company database.
Thanks,
Kirk
*This post is locked for comments
All responses (
Answers (
