Core component of SQL Server for storing, processing, and securing data
Making sure that you have the most recent CU as Alberto says, is certainly a good idea. Check what SELECT @@version returns.
Then again, since installing the CU will stop and start SQL Server, this may cause problem go away just because of that.
If you are the more curious sort of person, you may want to some monitoring. Three options:
- Activity Monitor in SQL Server Management Studio.
- My stored procedure beta_lockinfo which will show you active processes.
- The stored procedure sp_WhoIsActive, originally by Adam Machanic.