I have a SQL express server. I followed the instructions up to the part where it states in step 4, "Right-click any table and select Query table." Each table already has it's default or own query. If I erase that and execute the query in this process, what will happen to the deleted query? Will the table keep the new query I just executed for defragging? I just want to make sure I don't break anything by doing this process because I am not a Database guy. Please advise.

Wanted to add to my questions. Why wouldn't I right-click my Solarwinds Orion database and select "New query..." then execute the script there? Why would I need to right-click and run the script in an existing table where I would need to erase the existing script and then execute another script within that table?

Step 4 does state to right click on your Orion database and select new query not sure where you saw to run on an existing table also if you are on core 2017.3 this is enabled by default in your polling settings.

The query in that example is turning on a setting within orion, and as Neo said, for the last several versions that option is already set so it is likely to not be much help to you, but maaaaaaybe your environment is different.

That query that comes up in SMSS is just a placeholder that would be like a show all kind of command. You can safely erase it, no problems. The commands they give you just update the contents of the settings table, when you go to close the window it will most likely ask you if you want to save the query but you do not need to.

You can pull up your new query at the database or table level, they would be the same thing for this purpose since the table you are acting on is defined in the query you paste in.

UPDATE dbo.Settings SET CurrentValue = 1 WHERE SettingID LIKE 'dbm-defragmentation-enabled%'

Automatic index defagmentation is configured on your SolarWinds database and you can now exit the program. This is not like Microsoft Office where you need to save your work which I thought I had to do. If you want to check to see that defrag is enabled, follow steps 1-5 again BUT this time execute this query instead:

Select * from dbo.settings where settingID like 'dbm-defrag%'

A table will show up. Look under the column "Name" for "Is defragmentation enabled?" and then look under the column "CurrentValue" for "1" that corresponds to "Is defragmentation enabled?" This "1" means that defrag is enabled. "0" means it is disabled.

Actions

More Like This

Retrieving data ...

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining.

SolarWinds uses cookies on its websites to make your online experience easier and better. By using our website,
you consent to our use of cookies. For more information on cookies, see our cookie policy.