Viewing 15 posts - 1 through 15 (of 475 total)
Exceptionally busy next few days coming, but I did rebuild this morning, set a trace, and did check once to find 0.04% fragmentation - not the usual leap to 66.-whatever%...
August 10, 2021 at 9:13 pm
Confirmed: 0 for index level, In-Row-Data, and trigger generated the expected email for each of an actual Insert, Update and Delete.
FWIW: This is not a end of the world scenario...
August 9, 2021 at 4:56 pm
So... since the trigger isn't catching it, is my next step Extended Events?
August 9, 2021 at 3:38 pm
It's coming from Table - Indexes - Reorganize. The underlying source is sys.dm_db_index_physical_stats, I believe.
After load - create index, as well as after rebuild or reorg, avg_fragmentation_in_percent = 0
August 9, 2021 at 3:00 pm
So, the trigger has been in place, but has not fired. It's simple: On I/U/D, send me an email with the user_name().
I rebuilt the index on Friday morning, this morning,...
August 9, 2021 at 2:08 pm
Couple of days later. Wish I had the query handy, but it's on my other workstation, the one with the fried HD from a power blip last Friday. Good thing...
July 26, 2021 at 5:54 pm
Won't be around for long, methinks.
Also, still on 2008, and XE was not friendly in the slightest back ...er... now 🙂 That said, can't wait to start playing with it...
July 26, 2021 at 5:16 pm
As mentioned, the index is created post-load.
Thanks for taking the time to respond. Trigger, here I come!
I'll let you know what I find.
July 26, 2021 at 4:59 pm
Ah, I should have been clearer. It is dropped and re-created monthly, populated with 1.8m rows, and then create the index. Within 2 days, the dm tables are showing fragmentation.
July 26, 2021 at 3:52 pm
If you have space on prod, restore it to second DB on prod server, remove unneeded tables/content, then back that up and restore to dev.
July 9, 2021 at 3:07 pm
Thank you all.
This was a purely educational matter.
I share your concerns re: cursors and dynamic SQL, but sometimes there is no other way.
At any rate, this report will likely run...
June 15, 2021 at 11:12 am
I could have been clearer: the logical reads are on the target of the INSERT.
It's an INSERT #Action/EXECUTE dbo.sp_executeSQL, inside a cursor. Could it be because it's dynamic SQL?
June 14, 2021 at 4:54 pm
I need to call the sprocs with named parameters, so I ended up just building a command in the cursor declaration.
I think there was always going to be some hard-code,...
April 30, 2021 at 1:30 pm
So I'm running a bunch of reports through a cursor. Different DBs, different subsets of the same list of reports.
A couple of the reports have additional parameters. I was hoping...
April 29, 2021 at 6:52 pm
Thanks for the succinct reply 🙂
For that matter, is there a way to even list the variables in the current scope?
April 29, 2021 at 6:17 pm