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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Blockings and server performance?

Author  Topic 

learntsql

524 Posts
Posted - 2010-07-27 : 06:58:01
Hi All,
I have 20 databases in single instance.
How blockings in one database effect on other database/Application or
Overall server performance?
Please guide me.
TIA.

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2010-07-27 : 13:17:40
Blocking in one database doesn't necessarily affect other databases, unless your queries span across other databases. But what blocking does is slow down your transactions, which could translate into consuming more system resources such as CPU and memory and thus affecting other databases.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

learntsql

524 Posts
Posted - 2010-07-28 : 00:43:09
Thanks Tara,
If the blocked transactions in one database consume more resourses like CPU and Memory then will it effect overall server performance?
then how to handle such kind of issues?
TIA.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2010-07-28 : 12:42:51
Yes it will affect the overall server performance. You handle them by fixing the blocking (fixing the queries, adding indexes, removing indexes, fixing code, changing the database design, fixing the hardware, ...).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site