Viewing 15 posts - 1,216 through 1,230 (of 22,202 total)
Since you're in 2008, you can take advantage of the system_health Extended Events session. system_health contains deadlock information that you can query as outlined here (yeah, yeah, RDS, but...
August 17, 2021 at 12:23 pm
I generally advocate against using the ring buffer. It affects the memory of the server in a negative way, worse than simply negative depending on what you're capturing. Instead, I...
August 17, 2021 at 12:13 pm
Is the query scanning the existing index or seeking against it? If it's a seek, and it's the cluster, I'm not entirely sure you'll see much of an improvement with...
August 17, 2021 at 12:09 pm
Keep an eye on CPU and waits, before and after.
August 10, 2021 at 3:02 pm
Thanks for the feedback, Grant. I am concerned. While I wouldn't expect such a thing to be "radical" in a test and development environment, seeing "some" thrash and having...
August 9, 2021 at 3:17 pm
Have any of you good folks used the "Automatic Tuning" feature of SQL Server 2016 for on-prem? If so, how'd it work out for you?
I ask because I have...
August 9, 2021 at 2:44 pm
Grant,
Thank you for your input. It is as valuable for me as all your comments and guidance always are, both here at SSC and in your books (I can...
August 6, 2021 at 2:35 pm
Meh.
It's a very mixed bag. It can improve performance a little in some workloads. It does nothing at all in a lot of workloads. For a few, really rare workloads,...
August 6, 2021 at 12:21 pm
Yes, extended events is great for this if you're comfortable working with extended events and have the skills needed to programmatically process the extended events results data. A lot...
August 4, 2021 at 6:07 pm
I'd go with either Extended Events (much less overhead than Trace AND can be filtered on capture which Trace can't do) or Query Store. If you want to capture lots...
August 4, 2021 at 1:13 pm
I don't understand what you're asking. You can make batch calls from code, almost exactly the same as calling procedures. You just change the command type. SSMS is also a...
August 4, 2021 at 12:37 pm
Here's a code sample showing how C# calls a stored procedure. Compare that to 'EXEC dbo.MyProc' in SSMS. One is a remote procedure call. The other is a batch...
August 3, 2021 at 3:41 pm
You can rebuild and reorganize columnstore indexes the same as rowstore. The reasons you do this are different though. It's not about fragmentation, because of how columnstore indexes are defined,...
August 3, 2021 at 11:33 am
August 2, 2021 at 3:04 pm
One huge note, I wouldn't recommend anyone "upgrade" a server to 2014 here in 2021. There are three other versions of SQL Server after 2014. All of them offer mechanisms...
August 2, 2021 at 12:10 pm
Viewing 15 posts - 1,216 through 1,230 (of 22,202 total)