• Shouldn't really be using SSMS on the Live server. It takes memory away from the system. SSMS should always be used remotely from your PC in my books. Especially when trying to find performance issues.