Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
software to manage the performance
- Thread starter ersatz
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
What?
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
what do you mean by 'buy of'?
are you leasing them or something
“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --
are you leasing them or something
“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --
- Thread starter
- #4
Take a look at
“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --
“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --
mrdenny
Programmer
- May 27, 2002
- 11,595
There are lots of peices of software out there to show you where the problems are. Fixing the problems are for the most part up to you.
Spotlight for SQL Server by Quest Software is a very good product. It's a real time only (for the most part) product. Meaning that you have to have it open on the screen for it to collect data. They also have an Enterprise Product call foglight will runs as a service and collects data 24x7 for historical reporting. Last time I spoke with Quest spotlight came with Foglight when you purchase the SQL Agents for Foglight.
Spotlight is on of the better products.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
Spotlight for SQL Server by Quest Software is a very good product. It's a real time only (for the most part) product. Meaning that you have to have it open on the screen for it to collect data. They also have an Enterprise Product call foglight will runs as a service and collects data 24x7 for historical reporting. Last time I spoke with Quest spotlight came with Foglight when you purchase the SQL Agents for Foglight.
Spotlight is on of the better products.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
- Thread starter
- #7
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question