?
Solved

SQL Server capacity and performance monitoring query

Posted on 2014-04-11
1
Medium Priority
?
594 Views
Last Modified: 2014-04-14
1) Are there any useful SQL scripts to list remaining space, autogrow type settings on a SQL instance on 2008 SQL Server? as a general capacity monitoring and configuraiton script? what exactly do you look for here?

2) Are there any free tools to identify performance issues and probable root causes on SQL Server 2008, ie highlight where performance issues are coming from/the misconfiguration causing the performance issues?
0
Comment
Question by:pma111
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 38

Accepted Solution

by:
Jim P. earned 2000 total points
ID: 39994125
Are there any free tools to identify performance issues and probable root causes on SQL Server 2008,

For monitoring I would look at Confio's  Ignite Free. I would setup a different server/workstation to run it to monitor the production server(s). It can run on SQL Express though. It doesn't have all the alerts in the free version, but it allows for tracking the "hot" spots.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question