Quick note here describing how to find out what a connection to a Microsoft SQL Server is doing. First you need to find the connection. Display current connections Use the sp_who2 stored procedure to find the current connections. Use the following information to determine the connection of interest. SPID – The ID of the connection. […]
Showing 2 results for the tag: SQL Server.
I’m in the process of moving to a two-machine development environment so my SQL Server processing will occur on one machine and my application will run on another machine. I’m making this change since I’ve found that a single machine with 4GB can’t handle both processing 4 million records AND running an application that processes […]