|Recently, I was speaking with a user of GP who said performance seemed slow within GP, particularly when logging in or closing GP. At first, I thought it may be related to the Menu Master table (SY07110) growing too large, but that didn’t appear to be the issue.
I then recalled a similar support case from a while ago where there were options within SQL Server that were marked incorrectly – Auto Close and Auto Shrink. These two options should always be marked as False for the DYNAMICS and GP company databases.
If you only have a few databases to check, you can simply go into the properties of each database through SQL Server Management Studio to verify that each of these settings are set to False. However, if you have quite a few companies, you can use the SQL script below to check the setup of these options for all databases. If any of the databases return a 1, then that database has the option marked as True and you should change it to False.
SELECT [name] AS DatabaseName
, CONVERT(varchar(100),DATABASEPROPERTYEX([Name] , ‘Recovery’)) AS RecoveryType
, CONVERT(varchar(10),DATABASEPROPERTYEX([Name] , ‘IsAutoClose’)) AS AutoClose
, CONVERT(varchar(10),DATABASEPROPERTYEX([Name] , ‘IsAutoShrink’)) AS AutoShrink
Order By DatabaseName
About PartnerMore info about Summit Group Software
The goal of Summit Group Software is to improve the business success of our clients by providing an incomparable level of information technology services and solutions. As a Microsoft Dynamics Partner we are focused on the Microsoft Dynamics GP and Microsoft Dynamics CRM product lines.
Our philosophy is very simple. We believe in building customer relationships and providing value to our clients. We provide you with talented, certified professionals and a proven methodology that will exceed your expectations. We are ready to work with you to ensure that the investment you make in a solution meets the specific needs of your organization, both now and in the future.
With our skilled team of consultants we successfully service clients throughout the United States and Canada covering dozens of different industries. Don’t take our word for it though. Contact us today and we’ll be happy to put you in contact with any of them so you can hear it for yourself.