Hi @Michael W87 ,
To check how much resources your SQL Server 2012 Standard is using, you can use Activity Monitor or Performance Monitor (PerfMon).
Using Activity Monitor:
Connect to your SQL Server instance using SSMS.
In Object Explorer, right-click the SQL Server instance and select Activity Monitor.
In the Activity Monitor, you can see the current resource usage of your SQL Server, including CPU usage, memory usage, and disk I/O.
Using PerfMon:
Open PerfMon by typing "perfmon" in the Run dialog box or in the Command Prompt.
In the Performance Monitor, you can add counters to monitor the resource usage of your SQL Server, including Processor Time, Memory\Available MBytes, Physical Disk\Disk Reads/sec, and Physical Disk\Disk Writes/sec.
Regarding using SQL Server 2022 Express, it has some limitations that you should consider before making a decision:
If your databases are less than 10GB in total and the server has fewer than 4 cores, then SQL Server 2022 Express may be a good fit for your needs. However, if you have more cores or more memory, you may want to consider other editions of SQL Server.
Of course it has functional limitations, you can check my previous link for details.
Lastly, upgrading to the latest version of SQL Server may not always be necessary. However, upgrading to a version that is still under mainstream support is recommended for security and bug fixes.
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".