Unanswered: SQL server behaving strange. Help !!!!!!!!!!!!!!
Everthing was fine till yesterday but I walk in this morning and my server is behaving strange. We have a app and db on the same server (I know this is bad but I could never convince my management to buy another server). This morning when I walked in, I see that SQL Server is taking all the CPU and memory. I have no clue where to start troubleshooting the problem. Can you please tell me where to start and what all to check. Some possible scenarios when things like this could happen? Any help is greatly appreciated. (I did fix the amount of memory SQL Server could use, earlier it was dynamic). I rbooted the server and it did not change anything.