Maybe the best thing to do for 200 tables is to have a script that generates the stored procedures for you?  I know there are such things around although I...

The 50 GB is just how much disk space the database takes up.  If you only have 10 GB of that space allocated to tables and indexes, then only that...

maybe you are thinking of Windows Internal Database, which is limited for size and usage

https://blog.sqlauthority.com/2015/09/30/sql-server-what-is-windows-internal-database-edition/

SQL Server Embedded is what is typically called Compact edition, which Microsoft has not updated...

What are your backups saved on and where are they located, locally or somewhere on the network?  Different troubleshooting may be required for each case.

Are the backups compressed?  Unless you...

Congrats Luis!  hope the family is doing well 🙂

I've typically only used these queries when there is a problem happening at the moment instead of constantly.  I have other software doing general performance monitoring that I look at...

It may help to look at the execution plan.  In the query I posted in the far right there is a column query_plan that would have a hyperlink to look...

Can you tell what the session is waiting on?  suspended just means it's waiting, likely page I/O

SELECT s.session_id, s.host_name, s.program_name, s.client_interface_name, s.login_name, s.status AS session_status,
  ...

Probably the easiest way to do it would be to have a SQL Agent job with your PowerShell code in it (a SQL Agent step can be PowerShell) and then...

Scott,

I don't think your suggested index would help much, since the WHERE tab1.Column3 = 10 condition isn't as much the problem as the triangular self join from tab1 to tab2...

If your application doesn't have a log that you can use, I'd start by seeing if there are any sessions actually connected to PC-B from PC-A:

SELECT s.session_id,...

It's difficult to tell offhand what is happening on your system.  If you are having a lot of blocking happening, here's a query to help find the lead blocker(s) of...

Could this be solved after the migration with an extra DNS entry that has the old server name but the new server IP?

Actually this is more likely a problem of the 2 different ways of running the same query having different connection properties.  I'd look there first.  The most impacting setting is ARITHABORT

Here's...

Having only one node selected as a Possible Owner means you cannot fail over from the N1 server to the N2 server.  If these are the only 2 nodes in...