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 |
|
rikleo2001
Posting Yak Master
185 Posts |
 Posted - 2005-10-17 : 22:13:35
|
| Hi All,I am running sql 2000, currently I have a database Size 11 GB..running a ASP.NET application from 20 Clients and Coomunication Server which periodically communicate with server to pull and push the data.My Problem is My Queries response is tooo slow, even though I have Indexes on all tables. Is that huge database size causing the Issue? or is there anything i need to focus on more..Secondly If i need to archive the Database like in 6 month Periods, what are the best practice, so that I can still access to old data.Like 2003 Databse2004 Database2005 databaseis that approch is fine ? or do I need to adopt anyother approch..Thanks in advance...Rik |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-18 : 01:05:20
|
| you can archive to another database through dts package run every n-period and retain "active" records e.g. 1 year on production, 1 year on archive, this way you get 2 years of "active" recordsthen you can backup the archive database before deleting the records prior to retaining recordsif you need the previous records that are not retrievable from the archive database, you can always do a restore--------------------keeping it simple... |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-18 : 03:10:55
|
| You could use horizontal partitioning VIEWs to join several databases together too - that way you could have a Current Year database, for speed, but still use the VIEWs when you needed to query all data.11GB isn't all that big, but it would almost certainly need to be running on some good hardware, and have been carefully tuned, to run fast.Are you using Dynamic SQL from ASP to access the database, or Stored procedures?Kristen |
|
|
|
rikleo2001
Posting Yak Master
185 Posts |
Posted - 2005-10-19 : 21:47:35
|
| Sorry for being late. I thought I will get email if somebody did post under my thread like other forum, might be there are settings, which I am not familiar with....AnywayThanks for your help.Kristen..I am using SQL Server 2000 Standard Edition..And I am using Views from ASP Forms and Executing Stored procedures from the Backend..But it still taking ages...Let me give you an example...I posted some of my Code under the following thread. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56555I mean to talk in this forum that I can get differant views on database size and my actual problem.Thabks again and waiting for your favourable response.SKR |
|
|
|
|
|
|
|
|
Size of SQL 2000 Database