Versions Compared

Old Version 3

changes.mady.by.user Former user

Saved on

compared with

New Version 4

changes.mady.by.user Square 9 Support

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
bgColor#fff
  1. Open SQL Server Management Studio (SSMS)
  2. Expand "Databases" in Object Explorer
  3. For each of your production databases and GlobalSearch System databases, do the following:
    1. Right click the database and click "Properties"
    2. Open the "Options: page
    3. Under the "Other Options" Section locate "Auto Close" under the "Automatic" Section (you may have to scroll upwards to find this section)
    4. Set "Auto Close" to False
    5. Hit "OK"

Problem

After an Upgrade, System Performance is Much Slower

Some clients may notice some system slowness issues after an upgrade. It may be due to a SQL Upgrade Script not properly running at time of upgrade. This is typically due to an install with insufficient SQL Permissions. Luckily, running the upgrade scripts is easy and can be done within minutes.

Info
titleRemember...

Always back up your SQL Server before running any sort of script against a production database. Additionally, large databases may take some time to upgrade. To prevent deadlocks, it's advisable to run these scripts either after hours or off-peak hours.

Solution

Run Upgrade Scripts

Panel
bgColor#fff
  1. Open SQL Server Management Studio (SSMS)
  2. In your Server Getsmart directory, locate a Script called "SSMasterUpgrader.sql" and run this script in SSMS
  3. In your Server Getsmart directory, locate a Script called "UpgradeScript.sql"
  4. Do the following for all your production databases
    1. Load this script into SSMS but do not run it.
    2. Do a "Find and Replace" search for "DynamicSQLfjdksahfjilsda" and replace with your production Database name (you should find three instances of this)
    3. Once the Database name has been properly set, run the script
    4. Repeat as necessary for each database

Filter by label (Content by label)
showLabelsfalse
max5
spacesS9SKB
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "sql" and type = "page" and space = "S9SKB"
labelssql

...