Viewing 15 posts - 1 through 15 (of 36 total)
So after doing some more digging, it looks like new connections come in and are part of the internal workload group initially before they are assigned to a user defined...
December 22, 2022 at 3:32 pm
I agree. We are testing in lower environments. Thanks for sharing the article.
Very odd that a technology will indefinitely grow a data file for a database that is 500MB normally...
February 7, 2020 at 6:28 pm
I've got an extended event running now that will hopefully capture the next growth event(s) with more detail.
February 7, 2020 at 5:34 pm
Just happened again. I have pulled the growth report. Autogrowth just starts going haywire and growing and growing until there is no more space on the drive... lol. There is...
February 7, 2020 at 5:18 pm
As far as I know you would need to set up some sort of activity collection that logs to a table. But even then, you might miss some things if...
October 4, 2018 at 4:28 pm
Do you have any logs? I would check secondary sql logs and primary. It might have just needed time.
October 4, 2018 at 12:28 pm
September 28, 2018 at 11:38 am
I want to use the...
September 28, 2018 at 11:34 am
You could create a separate AD group ADG2. Add ADG2 Group as a member of ADG1. Add ADG2 to SQL server, grant it dbo on the select database. That way,...
September 28, 2018 at 11:21 am
You lose any routing. IE, if you have the listener specified in connection strings, those connections don't happen. Where normally, it would route traffic to the primary or secondary depending...
September 28, 2018 at 10:59 am
Obviously you want to get to the root of the issue that is causing the sudden spike but I might recommend looking into buffer pool extension if you have a...
September 27, 2018 at 2:02 pm
Do you have 2 jobs on the primary executing the same package at the same time?
September 27, 2018 at 11:22 am
I believe you can see the server that attempted to execute the package if you dig a little deeper in the report
September 27, 2018 at 10:04 am
As far as I know you need some level of access to view the agent history / job activity monitor on each node.
Since they are all trying to...
September 27, 2018 at 9:38 am
September 25, 2018 at 1:05 pm
Viewing 15 posts - 1 through 15 (of 36 total)