Speed up very slow sql database

Question

Speed up very slow sql database

mias.louw

Old Hand

Points: 369
More actions
October 30, 2012 at 5:57 am

#270331

I have a 1.2 GB database, and it is responding very slow. Is there steps i can take to speed it up?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

Performance tuning is a huge topic, is there something specific that is causing the majority of the problems or is it more of a general how do I troubleshoot this issue?

Sean Pearce SSCoach Points: 15999 More actions · Answer 2

Troubleshooting SQL Server: A Guide for the Accidental DBA is a good place to start.

http://www.sqlservercentral.com/articles/books/76296/

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

mias.louw Old Hand Points: 369 More actions · Answer 3

Thank you. I understand thet this is actually a difficult question for one line on a forum

mias.louw Old Hand Points: 369 More actions · Answer 4

mias.louw

Old Hand

Points: 369

October 30, 2012 at 6:41 am

#1554130

Thank You.

Ant-Green SSC Guru Points: 113507 More actions · Answer 5

Some other good things to read up on

Poor Performing SQL Part 1 - http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

Poor Performing SQL Part 2 - http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Stairway to SQL Server Indexes - http://www.sqlservercentral.com/stairway/72399/

Gail's articles - http://www.sqlservercentral.com/Authors/Articles/Gail_Shaw/148127/ - Especially the introduction to indexes articles