Viewing 15 posts - 31 through 45 (of 254 total)
February 22, 2019 at 2:19 pm
February 22, 2019 at 2:17 pm
I believe I was looking something similar to this in order to get which session or code was taking up the whole chunk of memory due to maybe poorly written...
February 22, 2019 at 2:13 pm
February 22, 2019 at 1:49 pm
February 22, 2019 at 1:42 pm
Okay so the next step is if we know that sql server is the culprit then how do we basically get to the query that is causing memory spikes. I...
February 22, 2019 at 12:28 pm
You can refer this post.
https://www.sqlservercentral.com/Forums/Topic1560182-1550-1.aspx
February 18, 2019 at 12:25 am
I think the error is pretty obvious. Can you explain what is the end goal and why you are trying to do what you're intending to do.
February 18, 2019 at 12:10 am
AlwaysOn FCI's isn't worth it with 2 node cluster...you're adding more complexity to deal with. I would suggest play simple with 2 standalone nodes clustered with AlwaysOn AG and you...
February 17, 2019 at 11:56 pm
Why do you have 2 log files in the first place.
February 17, 2019 at 11:51 pm
January 16, 2019 at 12:15 pm
January 15, 2019 at 1:18 pm
goher2000 - Tuesday, January 15, 2019 12:31 PMtry using kill UOWhttps://docs.microsoft.com/en-us/sql/t-sql/language-elements/kill-transact-sql?view=sql-server-2016
sys.dm_tran_active_transactions
No luck.
January 15, 2019 at 12:58 pm
January 15, 2019 at 12:16 pm
Viewing 15 posts - 31 through 45 (of 254 total)