Viewing 15 posts - 1 through 15 (of 74 total)
If you are interested in Currently running queries and not already completed queries in cache, I would suggest a job that runs every X seconds that look at current running...
March 19, 2024 at 8:29 am
Thank you!
I found this under Advanced Publish Settings
Appreciate your help!
October 5, 2023 at 2:30 pm
thank you
I just came across this table sys.dm_db_persisted_sku_features
Which looks like it could be what I was looking for
July 12, 2023 at 1:53 pm
Thank you for your input.
Having 1 Distributor server, is it then advised to have multiple distribution databases? For the multiple Subscribers?
Something like:
Server A = Publisher
Server B...
November 21, 2018 at 1:40 am
April 26, 2018 at 12:31 am
I have not made any changes to indexing on the subscriber/distributor - I only...
April 24, 2018 at 2:28 am
April 24, 2018 at 1:12 am
Hi,
One publisher server, 27 publications, One distribution database.
I think you could be right , because I have also noticed that when the CPU spikes on the Publisher,...
April 23, 2018 at 6:51 am
The changes they want to make is any Alteration on an existing table
eg. ALTER TABLE .... ALTER COLUMN....
or
ALTER TABLE... ADD ....
Their permissions are
...
February 1, 2018 at 3:06 am
We have dedicated support staff that can make these alteration - and yes it is all under change control. All changes are reviewed by me in any way. But I...
February 1, 2018 at 2:39 am
Yes he has restarted SSMS quite a few times and it still happens.... The strange thing is that this does not happen with all his queries. It seems random
September 29, 2017 at 5:59 am
Hi
I checked that - that is the autoCommit I was referring to... it aint ticked...
September 29, 2017 at 5:46 am
I would like to ask one more thing:
I am seeing a high ratio of Recompilation - on average over 50% of incoming batches and of Compilations per second.
How...
September 6, 2017 at 8:35 am
Viewing 15 posts - 1 through 15 (of 74 total)