How to index tune 15 minutes of live activity?

With SQL 2005 Std. I once saw there is a way to use PerfMon (I think), or
some other logging tool, grab 15 minutes of data being executed on the live
SQL Server, and then do an index tuning analysis on that. Can someone
please tell me how?There is a tutorial on Database Engine Tuning Advisor on BOL. Go to SQL
Server 2005 Tutorials, SQL Server Tools Tutorials, Database Engine Tuning
Advisor Tutorial.
Ben Nevarez, MCDBA, OCP
Database Administrator
"D. Patrick" wrote:
> With SQL 2005 Std. I once saw there is a way to use PerfMon (I think), or
> some other logging tool, grab 15 minutes of data being executed on the live
> SQL Server, and then do an index tuning analysis on that. Can someone
> please tell me how?
>
>sql

How to index tune 15 minutes of live activity?

With SQL 2005 Std. I once saw there is a way to use PerfMon (I think), or
some other logging tool, grab 15 minutes of data being executed on the live
SQL Server, and then do an index tuning analysis on that. Can someone
please tell me how?There is a tutorial on Database Engine Tuning Advisor on BOL. Go to SQL
Server 2005 Tutorials, SQL Server Tools Tutorials, Database Engine Tuning
Advisor Tutorial.
Ben Nevarez, MCDBA, OCP
Database Administrator
"D. Patrick" wrote:

> With SQL 2005 Std. I once saw there is a way to use PerfMon (I think), or
> some other logging tool, grab 15 minutes of data being executed on the liv
e
> SQL Server, and then do an index tuning analysis on that. Can someone
> please tell me how?
>
>

How to include 3rd party charts in Reportservice 2005

Can someone help me how to include 3rd party/cystom charts in Reportservice 2005? (=non std charts!)

If the third-party chart is not designed for RS (it is not designed as a custom report item), you won't be able to use that control. If by a custom chart you mean your own chart control, you can convert it to a custom report item as shown here, and use it on your reports.

how to implement the sql server mirroring?

i have two computers with Sql server 2000 std edition(SP4) and windows 2003 std edition(SP1).

how should i do to balance the loading of sql server and sync these two servers?

The sql server mirroring means that if one server is down, then the other one will replace it?

Database Mirroring is a feature in SQL Server 2005 SP1.|||can i use sql server 2005 to mirror a database of sql server 2000 ? or, both of these two servers must run the 2005.|||both the servers must run 2005. By default db mirroring is disabled. You need to enable it using trace flag 1400