Re: Issue with a table that is 75%-80% of the database size
From: wei xiao [MSFT] (weix_at_online.microsoft.com)
Date: 08/31/04
- Next message: John Peterson: "Re: How can I back up a log-shipped database?"
- Previous message: Lucas Tam: "SATA RAID 5 Performance"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 31 Aug 2004 14:16:17 -0700
SQL Server 2000 does not support table partitioning. However, if you OLTP
query is simple enough, you might be able to use partitioned view to achieve
a similar result: create serveral tables with the same schema, then create a
view to union them together. If this is possible, then you can use put each
table in its own filegroup and use a filegroup based backup stragtegy.
Regarding reducing backup time, is your database recovery model simple or
full? Have you tried database differential backup?
SQL Server 2005 beta 2 has a table partitioning feature that might help both
your query response time and backup time. Please see this article for some
overview of SQL Server 2005 for DBA:
http://www.microsoft.com/technet/prodtechnol/sql/2005/maintain/sqlydba.mspx
-- Wei Xiao SQL Server Storage Engine Development This posting is provided "AS IS" with no warranties, and confers no rights. "Mitra Fatolahi" <anonymous@discussions.microsoft.com> wrote in message news:008d01c48eb2$150f1790$a401280a@phx.gbl... > Hello All, > > I need help to figure out what I could do about a big > issue that we have with our database size. > Our database easily grows to a size over 250 GB and up. > And the majority of the data (about 75%) is stored in > this one table (tb_content)with several columns in which > we are storing text in its text data type column. > The database is used for online transaction processing > application. > Users connect to the database through a Query application > to query for a particular row of this big table > (tb_content). Of course the query inlcudes joining few > other tables in the database as well. After the result is > returned to the users, users would update the data in > serveral tables using the application. > > The concerns are to improve the response time for each > query and reduce the time that it takes to backup the > database. > We were able to improve the query response time by > implementing Full-text indexing. > > Any suggestions or recommendations that would help to > reduce the size of a table that holds 75%-80% of the data > content of a database to help to improve the query > response time and the time that it takes to backup the > database. Is there a such thing as to create a > particulare table of a database on a different filegroup? > How about partitioning a particulare table? > > I appreciate your help! > > Thank you, > > -Mitra > > >
- Next message: John Peterson: "Re: How can I back up a log-shipped database?"
- Previous message: Lucas Tam: "SATA RAID 5 Performance"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
