In this article, Jon Smith describes how to investigate and understand performance so that you can decide how to balance these two goals.
Check it out...
We’ve just released a beta of SQL Prompt 6.5 which includes:
• Tab coloring improvements
• GROUP BY and ORDER BY suggestions improvements
• Import/export all options
• SQLCMD mode support
• Improvements to closing parentheses behavior
• Format actions
• Full suggestions for cross-database queries
• Temporary tables and their columns can now be renamed with F2
• Useful keywords are promoted to the top of the suggestions. For example, SELECT is shown above SAVE
Download the beta here: http://rd.gt/1ANXSPv
'Tempdb allocation contention' by Fabiano Amorim
If your code uses temporary tables, variable tables or dynamic cursors, this metric can help identify whether you have contention on tempdb allocation. Tempdb is shared by all databases and is used for many operations in a SQL Server instance, so it is common for tempdb to cause performance problems.
This metric returns the current number of pagelatch waits on the tempdb database. Any tempdb page allocation/deallocation or any space changing operations (such as INSERT) acquires a latch on PFS, SGAM or GAM pages to update the space tracking information. Since most temporary objects are heaps and are less than 64KB, a large number of such operations can cause excessive waits when acquiring latches.
Download it now.
Use this metric with SQL Monitor to monitor the number of indexes per database that haven't been used for the last month. Indexes that aren't in use should be removed because they can degrade INSERT, UPDATE and DELETE performance, and they use storage space.
Download the metric now...
While Microsoft gives us the SQL Server Data Tools (SSDT) as a good tooling for developing databases and the ability to store them into Team Foundation Server Version Control, it is only a entry point into the whole DLM (database lifecycle management) process.
This is an interview between Stefan Mieth (ALM Consultant) & Stephanie Herr (DLM expert at Redgate), introducing DLM as a concept to a German ALM audience. They talk about:
• what DLM means
• why DLM is important to an ALM audience
• diving a little bit into Redgate's tool SQL Source Control
• some suggestions about some simple things readers can do right away to improve their ALM / DLM processes
• how can TFS and SSMS work together?
• can database development be agile?
Give it a read here:
0800 169 7433
Hello, and welcome to the official Red Gate G+ page.
Red Gate is an internationally recognised software development company, which specializes in making ingeniously simple tools for development and data management. Over 620,000 users (and counting) rely on our tools to deploy their databases, manage their data, and improve their code.
Currently, there are 260 ‘Red Gaters’ working in our head office (and development center) in Cambridge, UK, with a further 30 people working in our US office in Pasadena, CA and in our East Asia office in Singapore..
Founded in 1999 by Simon Galbraith and Neil Davidson, Red Gate has rapidly grown over the past 13 years, building on our flagship tools SQL Compare, ANTS Profiler and SQL Prompt. We now offer a wide range of tools, focussing on the areas of delivery, data services, and development.