Viewing 15 posts - 1 through 15 (of 277 total)
I am doing it this way as it seems the only way:
Drop index ci1 on Z1
alter table Z1 Add constraint PK_Z1 primary key clustered (id) on [primary]
November 17, 2021 at 5:52 pm
Additionally, I am still strongly thinking about adding more files to TEMPDB. Because all the blockees choke on the tempdb latches.
September 25, 2021 at 2:14 am
Well. I am pretty sure that it is not due to recompile because it recompiles every time anyway as an old-asp-concatenated sql statement. But also I went the MAXDOP reducing...
September 25, 2021 at 2:12 am
Reducing MaxDop helped, actually. elapsed time reduced from seconds to milliseconds now.
Pre-creating temp tables did not change metrics but i understand what you all said regarding that it is the...
September 24, 2021 at 7:08 pm
I can read plans, to an extent. I just dont know how to attach them here :).
code rewrite is the very last resort (asp pages,....re-testing.. deployment/release...--noone wants do all that...
September 24, 2021 at 7:06 pm
physical cpu = 24, logical 48.
September 24, 2021 at 7:02 pm
We have 12 files for tempdb.
I am also thinking to reduce MAXDOP for that query only from 8 (server wide setting) to 4 or 2, too. Considering that LATCH contention...
September 24, 2021 at 3:51 pm
Thank you very much for the valuable feedback. So does my suggestion to add more data files to TempDb sound reasonable then?
September 24, 2021 at 1:55 pm
That's what I am doing right now, yes.
And thank you, let me make s strong case for Redgate SQL Search with my mgmt ...
September 19, 2021 at 2:08 pm
No source control.... It's a super secret, super ad hoc server...
September 19, 2021 at 1:21 pm
Any non 3rd party suggestions?
September 19, 2021 at 12:52 pm
Other than VIEW SERVER STATE, i mean..
September 7, 2021 at 4:41 pm
a couple more things we are thinking about:
Report showing database with excessive number of virtual log files. So we can then shrink and re-grow the tlog files to minimize vlog...
August 31, 2021 at 7:24 pm
The question is asked incorrectly. Someone asked me
IF I have a RaiseError WITH LOG in Catch block, and error is 'A transport-level error', should such statement/error be logged still in...
August 26, 2021 at 11:41 am
Viewing 15 posts - 1 through 15 (of 277 total)