使用 SQL Server 进行性能调整 [英] Performance tuning with SQL Server

问题描述

我试图联系我正在阅读的一本关于 SQL Server 查询性能的书的作者，但书中提供的电子邮件地址似乎不再存在.所以我决定问问社区.我正在粘贴我在下面写的消息.提前致谢.

I was trying to contact the author of a book I am reading on SQL Server query performance, but it seems the e-mail address provided in the book does not exis any more. So I decided to ask the community. I am pasting the messasge I had written below. Thanks in advance.

======

我买了你的书(SQL Server 2008 Query Performance Tuning Distilled)，我知道我的 SQL Server Express Edition 不支持运行必要的性能测试所需的许多重要工具.正如您所说，重要的是要有一个初始分析来检查有多少查询会损害数​​据库性能.由于我没有分析器，我无法知道.我已经下载了一个免费的项目工具，但恐怕我没有得到我需要的信息.在我看来，使用 SET STATISTICS 时应该显示的信息也不会出现在 SQL Server Express 中.

I have bought your book (SQL Server 2008 Query Performance Tuning Distilled) and got to know that my SQL Server Express Edition won't support many of the important tools I will need in order to run the necessary performance tests. As you have said, it is important to have an initial analisys to check how much queries are hurting database performance. Since I don't have profiler, I cannot know. I have downloaded a free project tool, but I am afraid I am not getting the information I need. And it seems to me, the information that should be shown when using SET STATISTICS won't appear in SQL Server Express either.

哪个是最低版本的 SQL Server，它将为我提供运行书中建议的测试的工具?是开发者版吗?它是否提供了我遵循示例所需的一切?

Which is the lowest version of SQL Server that will offer me the tools to run the tests suggested in the book? Is it Developer Edition? Does it offer everything I need in order to follow the examples?

另外，在 Express Edition 之上安装新版本(如 Developer Edition)有什么问题吗?还是我必须卸载以前的版本?

Also, is there any problem to install the new version (like Developer Edition) on top of Express Edition? Or do I have to uninstall the previous version?

我希望我不会打扰太多.我还要祝贺你出版了一本关于如此重要​​主题的好书.

I hope I am not bothering much. I would also like to congratulate you on the great book on such an important topic.

推荐答案

您可以花 49 美元购买 Developer Edition，这将为您提供完整的 SSMS(Management Studio)、分析器等工具.您可以将其安装在顶部Express(你可以在同一台机器上有多个 SQL Server 实例)，但如果你只在生产中支持 Express，我只会安装客户端工具，而不是安装一个恰好支持功能的 SQL Server 新实例当您移植代码时，您将无法实际使用.

You can buy Developer Edition for $49, and this will give you tools like the full SSMS (Management Studio), profiler, etc. You can install this on top of Express (you can have multiple instances of SQL Server on the same machine), but if you are only supporting Express in production, I would just install the client tools and not bother with installing a new instance of SQL Server that happens to support features you won't be able to actually use when you port your code.

但是，您可以在没有分析器和完整版本的 SSMS 的情况下完成很多关于故障排除性能的分析.您可以下载 SSMSE(Express 版本的 Management Studio)在这里，然后您可以针对 DMV 运行查询、检查查询计划并启动服务器端跟踪.无论如何，服务器端跟踪优于使用探查器 UI.服务器端跟踪可以将您在书中读到的所有性能指标记录到文件或表中，然后有一些函数可以轻松使用这些数据.

However, a lot of the analysis you can do on troubleshooting performance can be done without profiler, and without a full version of SSMS. You can download SSMSE (the express version of Management Studio) here, and from there you can run queries against DMVs, inspect query plans, and start server-side traces. Server-side traces are preferred over using the profiler UI anyway. A server-side trace can log all of the performance metrics you've read about in the book to a file or table, and then there are functions that allow easy consumption of that data.

事实上，您甚至可以在没有 UI 的情况下完成其中的许多事情，但开始时最好使用查询窗口，因此我会下载 Management Studio Express 并四处看看.

In fact you can even do many of these things without a UI at all, but to start it would probably be best to use a query window, so I would download Management Studio Express and poke around a bit.

PS 我让格兰特知道你在问.

PS I let Grant know you were asking.

这篇关于使用 SQL Server 进行性能调整的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！