Like TangoVictor, all of my stuff is on-prem as well, so my tips and advice may be useless.

Things I'd check (if possible) are logs on the server.  I'm thinking that...

I agree 100% with latkinson above.  I know when I attended my first PASS Summit I was VERY new as a DBA and all my learning was from google and...

I agree with Jeff here on not using a bat file for this UNLESS you are on SQL Express.  If you are on SQL Standard or higher, then I would...

I see 2 potential options here:

1 - contact WooCommerce to see if they can fix their data export to be in proper JSON format

2 - parse the text before importing...

Pretty sure that query store isn't going to help you there.  Query store is for storing execution plan statistics and it auto-flushes itself depending on the configuration you have set.

What...

My opinion - either can do the install, but the DBA needs to do the configuration.  The Server team should be able to handle an install as long as you...

My understanding is that they are 2 completely different data capture methods.  Ring buffer is a buffer and only exists in memory.  The advantage to this is that you are...

Pretty sure for this to work you are either going to need to have your stored procedure call a second stored procedure (likely the approach I would go with) OR...

I updated my post as the forum apparently didn't like the alias I used.

Since you are updating everything and you are doing it every 24 hours, I would recommend trying...

I would start development on this by making it work with a SELECT statement, which you can do with 2 JOINs.  The basic logic of it is you want to...

• This reply was modified 4 years, 1 month ago by Mr. Brian Gale.

Probably a silly question but is there a reason you are wanting to drop ALL clean buffers and free ALL the caches before you do your steps?  And why you...

I think that this page will help:

https://www.sqlshack.com/max-worker-threads-for-sql-server-always-on-availability-group-databases/

The link above says that for 500 databases with 1 primary, 2 secondaries, and 1 availability group your MINIMUM threads should be 1501.  The...

Something along the lines of:

string text = ex.Message;
string path = @"C:\Data\TextFiles\logFile.txt";

System.IO.File.AppendAllText(path, text);

Although, if you are "really new to C#", I would recommend reading up a bit on...

Quick google brought me to this:

https://www.linkedin.com/pulse/ssrs-2017-anonymous-authentication-problem-solved-frans-van-der-geer/

Following directions for SQL Server 2008 to configure something for SQL Server 2017 sounds like a recipe for disaster in my opinion.  The fun part...

I think the best way depends on what sort of issues you are looking for.

If it is frequent high CPU, then task manager or WMI or perfmon will tell you...