Jay B.
Senior Applications administrator with expertise in SaaS, Agile software development methodology and IT Operations
Any suggestions for MS SQL Monitoring tools?
Looking for more insight on SQL deadlocks and database usage. Looking for a tool that's easy to setup.
Answers (7)
Good question. Sorry, I don't really have any good suggestion. Whatever tracing tool our DBA tried seem to slow down the performance a lot. What I am doing right now is save errors into a log table that we created and then check which procedures are having deadlock or timeout errors at about the same time and see if we can improve them. Adding "with (nolock)" to some select statements that we don't need to worry about dirty reads fixed some issues.
Jay, I don't know if you are asking for what SQL Server can offer you or for some 3rd party tool, but I strongly recommend to start off with the first one and if you need more (more in means of graphical representation, because there cannot be more information that the SQL Server itself can give you), then go and search or ask for another one.
I would recommend you to start by checking the link I added here for enabling the trace flag 1222 together with the query given(but think of ErrorLog space used) and/or capture the DeadlockGraph event in profiler as it gives nice visual representation of what have happened at the moment of the deadlock.
Hope that helps a bit! :)
Links:
If you are looking for 3rd party tools, then Idera and Redgate may be good starting places.
http://www.idera.com/SQL-Server/SQL-diagnostic-manager/
http://www.red-gate.com/products/dba/sql-monitor/
MSSQLTips has a Whitepapers section. One part of it covers essential performance tools. http://www.mssqltips.com/whitepaperlist.asp
not really. I have moved on to NoSQL (mongodb)
I'm not a DBA, but I got a recommended Nagios.
It's supposed to be robust; and allows you to monitor many things--not just your databases.
Links:
Wallace J.
Multimedia Producer, i3D Programmer, Acrobat 3D PDF, Android App, Virtual World & iTV Design, Kindle, Nook & Sony eBooks
Best Answers in: Using LinkedIn (139), Computers and Software (32), Web Development (24), Business Development (22), Government Policy (20), Internet Marketing (18), Software Development (18), Work-life Balance (17), Staffing and Recruiting (15), Career Management (14), Education and Schools (13), Small Business (12), Graphic Design (11), Job Search (10), Advertising (10), Starting Up (10), Wireless (10), Search Marketing (9), Change Management (9), Branding (9), Ethics (9), Travel Tools (8), Economics (8), Public Relations (8), Organizational Development (8), Manufacturing (8), Professional Networking (8), Energy and Development (8), Enterprise Software (8), Mentoring (7), Health Care (7), Business Analytics (7), Quality Management and Standards (7), Market Research and Definition (7), Blogging (7), Telecommunications (7), Internationalization and Localization (6), Mobile Marketing (6), Sales Techniques (6), Product Design (6), Customer Service (5), Occupational Training (5), Employment and Labor Law (5), Events Marketing (5), Writing and Editing (5), Planning (5), Communication and Public Speaking (5), E-Commerce (5), Freelancing and Contracting (4), Venture Capital and Private Equity (4), Government Services (4), Environmental Health (4), Direct Marketing (4), Viral Marketing (4), Supply Chain Management (4), Distribution (4), Professional Books and Resources (4), Business Plans (4), Computer Networking (4), Business Dining and Entertainment (3), Hotels (3), Event Marketing and Promotions (3), Conference Planning (3), Conference Venues (3), Customer Relationship Management (3), Lead Generation (3), Social Enterpreneurship (3), Project Management (3), Engineering (3), Green Products (3), Biotech (3), Databases (3), Information Security (3), Purchasing (2), Air Travel (2), Accounting (2), Financial Regulation (2), Personnel Policies (2), Public Health and Safety (2), Exporting/Importing (2), Offshoring and Outsourcing (2), Criminal Law (2), Contracts (2), Corporate Governance (2), Currency Markets (2), Personal Debt Management (2), Wealth Management (2), Green Business (2), Business Insurance (1), Commercial Real Estate (1), Facilities Management (1), Regulation and Compliance (1), Car and Train Travel (1), Certification and Licenses (1), Resume Writing (1), Budgeting (1), Corporate Debt (1), Foreign Investment (1), Corporate Taxes (1), Risk Management (1), Compensation and Benefits (1), International Law (1), Treaties, Agreements and Organizations (1), Finance and Securities Law (1), Intellectual Property (1), Guerrilla Marketing (1), Commodity Markets (1), Equity Markets (1), Nonprofit Fundraising (1), Nonprofit Management (1), Inventory Management (1), Personal Investing (1), Personal Real Estate (1), Franchising (1)
MySQL Workbench
Hi, if your problems are just the death lock, a good and simple tool to monitor this problem is block monitor http://sql-tools.net/blockmonitor/ , the interface is simple and very intuitive, and is not an expensive tool to purchase.
This tool is very good to monitor death look, but not so good to monitor general performance or health of the data base, is more like and specific tool but very simple and cheap, around $200 USD.
I hope this work for you.
