Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
samhastings
Starting Member
1 Post |
 Posted - 2010-10-20 : 05:23:04
|
| For the past couple of months we've been experiencing frequent issues with very slow speeds on our local development server. I've narrowed down the cause to SQL Server 2005 running extremely sluggishly. FWIW, we're using Windows Server 2003.On a good day, database queries run instantly — on a bad day, even the simplest of queries (such as a SELECT * query with no conditions on a table with 5 rows, or even a USE [database] query) take up to 20 seconds to execute, even when executed via Management Studio.There are only two developers using the server. It does not power any live sites, just local mirrors of our websites, accessed exclusively via our local firewalled network.I'm a developer and not a DBA so am completely new to monitoring and analysing performance of SQL Server.If anyone could give me some pointers on how to pinpoint and troubleshoot the cause(s) of our issues I would be very grateful.Thanks for reading! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Troubleshooting slow speeds on local server