How to use partitioning in SQL Server database to avoid ‘timeout’ errors

Tags:
Partitions
SQL error messages
SQL Server performance tuning
Timeout
We have over 300 stores, and with each store having 30gb+ databases, each server is being upgraded to at least 6gb+ memory which is being forced allocated to SQL Server. I want to start to partition the existing SQL Server database by date. How do I go about doing it, because I have absolutely no idea? By the way, the stores experience timeout errors every day and it's not the H/W), please help.
ASKED: April 30, 2008  6:01 PM
UPDATED: May 2, 2008  1:47 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

If you are using SQL Server 2000, you have to create new tables broken out by year, then manually move the data into those new tables. Then modify your code to search these tables.

If you are using SQL Server 2005 you can create a partitioned table, then move the data into the table.

The point of partitioning a table is to put more hardware behind a single table. If your hardware (disk drive) is not running beyond capacity then partitioning the table may not help.

I’d be curious to see how large your tables are, and what your indexes look like.

I’ve got a table which is 78 Gigs and runs very nicely. Until recently we had only 8 Gigs in the server.

If you are having performance problems I would start by looking at the indexes for tables that are having performance problems.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following