如何在数据库sql server 2012中找到哪个表或过程性能较差以及如何进行性能调优 [英] How to find which table or procedure has poor performance in database sql server 2012 and how to do performance tuning

问题描述

这是Rakesh



我是数据库管理的新手，Plz帮助我

Hi This is Rakesh

I am Fresher in Database Administration ,Plz help me

推荐答案

对于快速回答论坛，这是一个不恰当的问题！



首先研究主题 - MS Reference [ ^ ]



谷歌将提供更多关于监控和调整性能的文章，例如 https://technet.microsoft.com/en-us/library/ms187830 （v = sql.105）.aspx [ ^ ]

http://blogs.msdn.com/b/indrajit/archive/2013/12/12/sql-server-database-engine-performance-tuning- basics.aspx [ ^ ]



和http://blog.sqlauthority.com/sql-server-performance-tuning/ [ ^ ]。我推荐这个最后一篇博客，因为它通常包含非常有用的片段

This is an inappropriate question for a Quick answers forum!

Begin by researching the topic - MS Reference[^]

Google will supply with many more articles on monitoring and tuning performance e.g. https://technet.microsoft.com/en-us/library/ms187830(v=sql.105).aspx[^]
http://blogs.msdn.com/b/indrajit/archive/2013/12/12/sql-server-database-engine-performance-tuning-basics.aspx[^]

and http://blog.sqlauthority.com/sql-server-performance-tuning/[^]. I recommend this last blog as it often contains very useful snippets

这篇关于如何在数据库sql server 2012中找到哪个表或过程性能较差以及如何进行性能调优的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！