Viewing 15 posts - 46 through 60 (of 72 total)
Thanks for the responses.
I was digging into the DMVs and managed to replicate the sort of info DPA gave me.
I got nowhere with Solarwinds other than I now have a...
January 29, 2020 at 7:54 pm
January 22, 2019 at 1:57 am
December 29, 2018 at 8:04 am
Well I did log in and I see multiple threads in sp_who3 (that align with the CXPACKET waits I see).
I also see that CPU% recorded in SolarWinds (when the...
December 3, 2018 at 5:30 am
November 24, 2018 at 4:24 pm
Thanks Gail.
Couldn't think of any reason why it didn't work, so was just wondering if the install choked at some point.
Regards
Steve O.
October 30, 2017 at 7:57 am
What's SELECT @@Version...
October 29, 2017 at 9:31 am
GilaMonster - Sunday, October 29, 2017 9:09 AMThat event was added in SQL Server 2016
https://www.sqlskills.com/blogs/bobb/over-1000-xevents-in-sql-server-2016-ctp2-here-are-the-new-ones/
Thanks for the reply Gail.
I was...
October 29, 2017 at 9:21 am
Logged into 3 Instances as SA from same SSMS session
2 x 2014 Instances - returns 7604 Events from query
1 x 2016 Instance - returns 13065 Events from...
October 29, 2017 at 9:12 am
Thanks for the reply Steve.
I did get it working using OpenQuery, and my intent was to specifically to reduce the network overhead as you say.
I had fun...
October 28, 2017 at 6:45 am
Actually I think that I can get openquery to work - not sure why I couldn't do this earlier but still playing with it
Steve O.
October 14, 2017 at 8:55 am
October 14, 2017 at 7:42 am
Something along these lines I guess
http://www.sqlservercentral.com/scripts/Jobs/66476/
Just need to get my head around it - seems to produce a report for the previous...
October 7, 2017 at 6:02 am
Still browsing and this discusses the thoughts I had in more detail
https://dba.stackexchange.com/questions/35182/manually-set-log-file-size-after-shrink-sql-server-2008-r2
Just pondering the best way to tackle this.
Steve O.
September 17, 2017 at 3:43 pm
Viewing 15 posts - 46 through 60 (of 72 total)