Make sure you are running SP2 on both the server and on your workstation. SP2 makes the management studio experience faster. Is the slowness problem just with SSMS? Is all your traffic going through either a software or hardware firewall? If you have a software firewall, try disabling it temporarily. Any sort of security or A/V software running on the production server, or some intermediate box between you and production?
Good luck, Mike Chabot On Feb 1, 2008 5:41 PM, Bruce Sorge <[EMAIL PROTECTED]> wrote: > I have a SQL Server 2005 box that is very very show using SQL Server > Management Studio. The website works fine though. Entire site is dynamic > and it is working as fast as the day it went live. I did DBCC > SHRINKDATABASE assuming that it was getting bloated but nothing. And my > dev SQL Server is working fine. Just production. Anything that I can > look at? > > Thanks, > > Bruce > > -- > Throttle Jockey - > Why golf courses should be motocross tracks > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3029 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
