[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL loading metrics

Posted on 2013-12-04
1
Medium Priority
?
171 Views
Last Modified: 2013-12-10
I have a SQL 2005 instance with a lot of activity on it.  I would like to see some kind of loading usage information for the last couple of weeks, something that would tell me what time of the day it has the most users, and other relevant stats.  Ideally I would like to see a graph with this information.  Is there something already in SQL I could use for this?
0
Comment
Question by:navajo26354
1 Comment
 
LVL 14

Accepted Solution

by:
John-Charles-Herzberg earned 1500 total points
ID: 39695905
I think what you are looking for is SQL Monitor 3 at: http://www.red-gate.com/

This is a product review to have a look at also: https://www.simple-talk.com/sql/sql-tools/top-six-sql-monitor-metrics-for-analysis/

Thanks
JC
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

873 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