Hi. We have a Windows 2008 server running SQL 2008. The SQL instance will lock-up sometimes when the application runs a query. This happens about twice a week.
We need somebody with extensive SQL 2008 DBA experience to determine:
a) What exactly is locking up SQL 2008,
b) What we need to do to fix.
Skills: microsoft sql server administration, microsoft sql server programming