Error: For some reason, when I launch this application in the debugger using the normal Start Debugging command in Visual Studio, it launches, but it also produces the following warning: Resolution: Disable this option under Debug->Options->Suppress JIT optimization on module load (Managed only). Sources: https://stackoverflow.com/questions/38601643/error-you-are-debugging-a-release-build-of-x-dll
Stop using PRINT. Start using RAISERROR. PRINT PRINT with GO RAISEERROR with NOWAIT Source:
Sources: https://docs.microsoft.com/en-us/visualstudio/debugger/just-my-code?view=vs-2019
Error: Resolution: Run as Administrator Source:https://stackoverflow.com/questions/10716956/iis-does-not-list-a-website-that-matches-the-launch-url
Error: Fix: Turning off Silverlight debugging Go to the web application’s Properties. On the Web tab, turn off Silverlight. Source: https://stackoverflow.com/questions/42943239/vs2017-the-debugger-is-not-properly-installed-cannot-debug-the-requested-type
Error Handling Error Handling with Transaction
File Folder Location: PROFILER.EXE C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\ Running under a different domain… If you create a cmd file, you might need to copy over the cmd file to the profiler directory and run it from there. To filter to only Stored Procedures… Events -> Check... » read more
SQL Server Memory Usage: OS Memory Usage:
Windows Performance Monitor is a Microsoft Management Console (MMC) snap-in that provides several useful counters.
The SQL Server Activity Monitor gathers information about the monitored instance and displays the data in a series of collapsible panes. Right Click Server -> Activity Monitor The Activity Monitor is split up into a couple of different panes. Overview Processes Resource Waits data file input output Recent expensive queries Active expensive queries