Please help me
We use NAS for Job scheduling, and now the size of Object Cache is 64000KB. We have slowness of transaction the users cannot login sometime and so on.
Advice what should be done. Can I delete Job log entries and will it help to increase the speed of transaction. Should I reduce Object cache size? as I know max is 1GB?
Thanks
0
Comments
It is unlikely that the performance bottleneck is in Object Cache, especially not with a cache of 64000KB for the NAS, which does not use any GUI related objects.
and Is the Job entries log size can affect on job performance?
Deleting records from that table is likely not going to help.
In your place I would start by using client monitor or SQL profiler to identify bottlenecks.
Btw, what do you mean by "the users cannot login sometime"? Is there anything that is create by NAS that is also create during login?
It was SQL Server issue.