2 posts / 0 new
Last post
khartley
Millennium loading REALLY slowly on specific user login

Has anyone ever encountered the issue of Millennium loading and generally running extremely slowly on just one user's specific login? I have had the same login for 13 years now, and I have to wonder if it is just bogged down with data somehow, or maybe there's a cache that needs to be cleared. The lag between clicks ranges from 10 seconds to 30 seconds, making gift processing, making edits of any kind, and most functions nearly impossible.

Thanks for any input!

Kris

Diane Etienne
Millennium loading REALLY slowly on specific user login

Hi Kris

If you are a SQL shop, you can have your network administrators run a SQL trace while you reproduce the issue. In SQL server management studio>Tools>SQL Profiler Trace run a new trace. Under Events Selection tab choose All Events. Then under Events>Errors and Warnings >check off Exception and User Error Message. Then under Stored Procedures> check SP:Starting, SP:Completed and SP:Stmt:Starting and SP:Stmt:Completed and then click Run.  Log in to Millennium and then produce the slowness under your login. The trace will be capturing in the back end. We can hopefully then take a look at what is taking time to execute.  Once you have replicated the issue for a while, you can then have admin stop the SQL trace. Click File>Save As>Trace file and then you can email the trace file to my email diane.etienne@abila.com.

Please email me if you need any help with the above and I would be most happy to assist!!  I will go ahead and create a support ticket for this issue so we can troubleshoot further with you pending the trace file.

 

Diane

Diane Etienne
Millennium loading REALLY slowly on specific user login

Hi Kris

If you are a SQL shop, you can have your network administrators run a SQL trace while you reproduce the issue. In SQL server management studio>Tools>SQL Profiler Trace run a new trace. Under Events Selection tab choose All Events. Then under Events>Errors and Warnings >check off Exception and User Error Message. Then under Stored Procedures> check SP:Starting, SP:Completed and SP:Stmt:Starting and SP:Stmt:Completed and then click Run.  Log in to Millennium and then produce the slowness under your login. The trace will be capturing in the back end. We can hopefully then take a look at what is taking time to execute.  Once you have replicated the issue for a while, you can then have admin stop the SQL trace. Click File>Save As>Trace file and then you can email the trace file to my email diane.etienne@abila.com.

Please email me if you need any help with the above and I would be most happy to assist!!  I will go ahead and create a support ticket for this issue so we can troubleshoot further with you pending the trace file.

 

Diane