|
|
Visual Defrag
Defragmenting your databases is easy with Visual Defrag. Visual Defrag analyzes all the tables in each of the databases on your servers and tells you which ones need defragmenting. It alerts you to tables which are fragmented to the level whereby performance will be lost if action isn''t taken. So rather than throw more hardware at your slowing database servers, why not defragment your tables instead and see how your performance increases? Defragmentation is a vital step in ensuring your servers run at their optimum speed and efficiency, and Visual Defrag will ensure you have this aspect of your performance tuning plan taken care of. The best time to carry out any database maintenance or performance tuning on your servers is out of business hours or during periods of low activity if users have round the clock access to your databases. Visual Defrag has a built-in scheduler for SQL Server 2000 and 2005, so you can set up defrag jobs to happen when you want. If you have a table that regularly becomes fragmented, you need never lose out to decreased performance, because the scheduler lets you defragment as often as you need. So, you can be assured that your servers are performing just as they should be, even though you may not be in the office to monitor them. Visual Defrag lets you toggle between a graphical and textual display of the fragmentation state of your tables. For every database on the current server, you can see statistics or graphical representations of what is happening inside your tables. With the graphical display you can instantly see the condition of all the tables in your database and color-coding will alert you to the mostly heavily fragmented tables. You can also order the view of your tables by least or most heavily fragmented. If you need to show your managers how well your servers are performing, or want to monitor performance for day-to-day administration, Visual Defrag helps you by creating a summary report for each defragmented database.
Keywords: defrag defragment defragmentation index database microsoft sql server support bmp digital photographers
|
|
|
SQL Task Manager
SQL Task Manager makes monitoring SQL Servers easy. As a database or network administrator you can use SQL Task Manager to find out how many users are connected to each server and each database on that server, what queries are running and who is logged in. The graphical display shows how the server is performing and delivers instant information about disk and network activity, CPU and memory usage. Use SQL Task Manager to identify the causes of spikes in CPU and memory so action can be taken to keep the server performing at its best. As a developer you can use SQL Task Manager to see all the queries running on a selected SQL Server and instantly discover how many times each query has been run and even how many bytes each one has consumed. Easily spot dynamic T-SQL which can be converted to stored procedures to boost performance and speed up the return of data to users and customers through compiled query execution plans. SQL Task Manager lets you see who is currently logged in to the server, how many connections there are to each database and how long since each user connection was active. You can quickly decide whether or not a server can be stopped for maintenance or emergency repair work.
Keywords: performance monitoring performance tuning database microsoft sql server cpu connections users mail support input box
|
