-
Re: Index...on table...has fragmentation 90.00% and should be defragmented manually
kange0010 Feb 5, 2018 7:13 PM (in response to kange0010)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?
-
Re: Index...on table...has fragmentation 90.00% and should be defragmented manually
neomatrix1217Feb 5, 2018 8:06 PM (in response to kange0010)
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.
- Expand Databases > Your_SolarWinds_Database > Tables.
- Click New Query.
-
Re: Index...on table...has fragmentation 90.00% and should be defragmented manually
kange0010 Feb 6, 2018 1:02 PM (in response to neomatrix1217)neo,
You were looking at the other step 4. The step 4 that concerns me is for the SQL express server and that one states:
4. Right-click any table and select Query table.
-
Re: Index...on table...has fragmentation 90.00% and should be defragmented manually
mesverrumFeb 6, 2018 1:39 PM (in response to kange0010)
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.
-
-
Re: Index...on table...has fragmentation 90.00% and should be defragmented manually
mesverrumFeb 5, 2018 8:56 PM (in response to kange0010)
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.
-
Re: Index...on table...has fragmentation 90.00% and should be defragmented manually
kange0010 Feb 6, 2018 1:02 PM (in response to mesverrum)mesverrum,
So it would be okay to just create a new query in my server to execute the script then not save that new query? The defrag will still happen automatically every night?
-
-
-
Re: Index...on table...has fragmentation 90.00% and should be defragmented manually
kange0010 Mar 13, 2018 3:55 PM (in response to kange0010)3 of 3 people found this helpfulFigured it out. The steps for the SQL Server Express that I did were:
1.Open the Database Manager.
2.Click Add default server.
3.Locate and right-click your SolarWinds Orion database.
4.Select "New query..."
5.Execute the following query in the blank white area:
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.
-
Re: Index...on table...has fragmentation 90.00% and should be defragmented manually
er.vansh17091 Jul 24, 2018 9:15 AM (in response to kange0010)Hi All,
I know it old thread. Can you please let me know how to check the current value?
UPDATE dbo.Settings SET CurrentValue = 1 WHERE SettingID LIKE 'dbm-defragmentation-enabled%'
-
Re: Index...on table...has fragmentation 90.00% and should be defragmented manually
neomatrix1217Jul 24, 2018 9:24 AM (in response to er.vansh17091)
What version are you on? We have this enabled now by default.
Enable Automatic Index Defragmentation - SolarWinds Worldwide, LLC. Help and Support
-
Re: Index...on table...has fragmentation 90.00% and should be defragmented manually
mesverrumJul 24, 2018 10:24 AM (in response to er.vansh17091)
select currentvalue from settings where settingid like 'dbm-defragmentation-enabled%'
-
-