0
votes
1answer
189 views

Troubleshoot IIS 6 and Intermittent SQL Server Connectivity Loss

I am not a System Administrator, but I am temporarily trying to fill that role. I have 2 Windows 2003 Servers. 1 server has my Microsoft SQL Database (SQL Server 2005) and the other is the web ...
0
votes
1answer
390 views

Can't update SQL Server 2008 to SP3, it only offers the option to create a new instance

A colleague is attempting to update our server's SQL Server 2008 version 10.0.1600.22 (not R2) install up to SP3. Unfortunately, we can't work out where the "Update" button is; the installer seems to ...
1
vote
1answer
45 views

Troubleshoot DBMail in SQL Server 2005

On a SQL Server 2005 machine, I have DBMail setup and correctly configured. I am able to use "Notify Operator" and EXEC msdb.dbo.sp_send_dbmail to queue emails. But the problem is the queued mails ...
5
votes
6answers
806 views

How to do periodic Sql Server performance monitoring and troubleshooting?

What are the best tools and processes for periodically monitoring and troubleshooting sql server performance issues?