How to Optimize SQL Server 2008

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.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

How to Optimize SQL Server 2008

Author

Topic

exh
Starting Member

1 Post

Posted - 2009-11-25 : 05:36:13

Hi all,
i used to make use of an SQL Server 2008 from my web host provider but have now got my own server up and running with SQL Server 2008.

The difference is amazingly slow (my server). I do a lot of open/close connections with VB.NET (2008) application, have some tables with 100k+ records.

So even though my own server is in the LAN, it is slower than the SQL Server half way around the world of my web host provider.

Is there something completely obvious i have missed or not setup?

Any help / pointers would be greatly appreciated

Regards

Tony

support.sql
Starting Member

15 Posts

Posted - 2009-11-26 : 22:34:29

Hi

You can use @nalytics Performance Data Collector for Microsoft SQL Server & Windows Server,
this tool can help you to solve your performance problems, I have tested it works excellent

and it is very easy to configure and implement it.

Visit

http://www.analyticsperformance.com/

Regards

SQL Guru
support.sql@gmail.com

SQL Guru

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources