SQL Server 2005速度加快 [英] Sql server 2005 speed up

问题描述

您好

我有一个数据库可以保存3年的数据。是大约106 MB

我如何加速这个数据库？有没有可用于分割数据的脚本？



我尝试了什么：



我尝试收缩数据库。但结果是一样的。数据库太慢了

解决方案

如果不了解更多细节，几乎不可能给你一个具体的答案。您可以查看几个项目。



首先，最简单的方法是检查您的索引。如果你有索引，你真的应该在一些计划上重建它们。这是一个很好的链接，可以帮助您开始重建索引任务（维护计划） [ ^ ]。现在，如果您的表上没有索引，那么首先要开始。一个好的起点是使用Sql Data Tuning Ad visor。您可以做的是查看正在运行的查询，并查找where和group by子句。这是一个很好的起点。

Quote：

如何加速这个数据库？ / blockquote>这是回答无法回答的问题的好方法，感谢缺乏信息。



首先，解释模式，索引，查询的类型，通常的用法。

使用改善问题来更新你的问题。

Hello
I have one database that holds data for 3 years now. is about 106 MB
How can i speed up this database?is there any script that can use for fragmenting the data?

What I have tried:

I have try shrink database.but the result is the same.Database is too slow

解决方案

Without know more details it is nearly impossible to give you a concrete answer. There are several items you can look at.

First and probably easiest would be to check your index. If you do have indexes you really should put rebuilding them on some plan. Here is a good link to get you started Rebuild Index Task (Maintenance Plan)[^]. Now if you do not have indexes on your tables that is the first place to start. A good place to start is to use the Sql Data Tuning Ad visor. What you can do is look at the queries you are running and look for where and group by clauses. That is a good place to start.

Quote:

How can i speed up this database?

That is nice way to answer a question that can't be answered, thank to the lack of information.

To begin, explain the schema, the indexes, the kind of queries, the usual usage.
Use Improve question to update your question.

这篇关于SQL Server 2005速度加快的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！