Disk activity

We are about to go to SQL 2005 and that means getting some new Servers and i am wondering if our SAN is adequate.

I like to measure over the next few weeks the amount of data that is sent to the SAN and how long its taking to come back....i.e if someone is running a large report how much data is sent and how long it takes to return.

This is for 2000 SQL (i like to get all these results to build my migration plan and hardware configuration).

I like to see...........18 mb of data , date time and how much read / write etc if possible the sql.

Any ideas

The tools are:
SQL Server Profiler (search for Profiler in Books Online. There are many topics)
Performance Monitor

Also see SQL Server 2005 Books Online topics:
System Monitor Scenarios
How to: Correlate a Trace with Windows Performance Log Data (SQL Server Profiler)

|||

I looked at profiler but could not get the results i really wanted....

I wanted totally bytes read and write and how long it takes the san to deliver

i.e it was say a 100 mb data request ....i was trying to figure out the SAN response to this.

|||

Look at Performance Monitor (perfmon). It's under Administrative tools on the Start/Programs menu.

Check out the LogicalDisk and System Performance Objects and the counters in the list for each. The topics I mentioned above have some help on aligning a Profiler trace with a perfmon trace if that's useful.

|||

I got the following to run

Disk Write Bytes /Sec

Disk Read Bytes/Sec

Avg Disk Bytes Read

Avg Disk Bytes Write

Avg. Disk sec/Transfer

Split IO/Sec

%Disk Read Time

%Disk Write Time

Current Disk Queue Length

I think that get me in the right direction......

sql

Disaster

Hi Friends,
I want to know how disaster recovery work? It means What are the types
of Disaster why we planned for the recovery asn all those stuffs.
Please explain me briefly.
Thanks,
ManuSee this article.
http://databases.about.com/od/sqlserver/a/disaster.htm
Take alook into examples:-
http://www.sql-server-performance.com/disaster_recover_examples.asp
Thanks
Hari
SQL Server MVP
"Manu" <manojjkd@.gmail.com> wrote in message
news:1156161219.707153.306170@.b28g2000cwb.googlegroups.com...
> Hi Friends,
> I want to know how disaster recovery work? It means What are the types
> of Disaster why we planned for the recovery asn all those stuffs.
> Please explain me briefly.
> Thanks,
> Manu
>

Disaster

Hi Friends,
I want to know how disaster recovery work? It means What are the types
of Disaster why we planned for the recovery asn all those stuffs.
Please explain me briefly.
Thanks,
ManuSee this article.
http://databases.about.com/od/sqlserver/a/disaster.htm
Take alook into examples:-
http://www.sql-server-performance.c...er_examples.asp
Thanks
Hari
SQL Server MVP
"Manu" <manojjkd@.gmail.com> wrote in message
news:1156161219.707153.306170@.b28g2000cwb.googlegroups.com...
> Hi Friends,
> I want to know how disaster recovery work? It means What are the types
> of Disaster why we planned for the recovery asn all those stuffs.
> Please explain me briefly.
> Thanks,
> Manu
>

Disable the use of Enterprise Manager

I have created a new DB user, ABC, for using ASP.NET application to
connecting to SQL Server. Does it means this ABC user can logon in the
Enterprise Manager to view the data without using the web application' if
so, is there any way to block this ABC user from viewing data in Enterprise
Manager?> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application'
Yes.
> if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
No. I suggest you use stored procedures and only allow your users to execute the stored procedures.
You might also want to read about application roles...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Grey" <erickwyum@.i-cable.com> wrote in message news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application' if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
>|||TO add to Tibor's comments, if you really, really want that capability, use
Application roles. They allow you to give permission when access is via the
application, but the end user does NOT have a permissions, so he can not go
through SEM or query analyzer and see anything.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Grey" <erickwyum@.i-cable.com> wrote in message
news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application' if
> so, is there any way to block this ABC user from viewing data in
Enterprise
> Manager?
>

Disable the use of Enterprise Manager

I have created a new DB user, ABC, for using ASP.NET application to
connecting to SQL Server. Does it means this ABC user can logon in the
Enterprise Manager to view the data without using the web application? if
so, is there any way to block this ABC user from viewing data in Enterprise
Manager?
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application?
Yes.

> if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
No. I suggest you use stored procedures and only allow your users to execute the stored procedures.
You might also want to read about application roles...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Grey" <erickwyum@.i-cable.com> wrote in message news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application? if
> so, is there any way to block this ABC user from viewing data in Enterprise
> Manager?
>
|||TO add to Tibor's comments, if you really, really want that capability, use
Application roles. They allow you to give permission when access is via the
application, but the end user does NOT have a permissions, so he can not go
through SEM or query analyzer and see anything.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Grey" <erickwyum@.i-cable.com> wrote in message
news:eMZrdqsnEHA.1160@.tk2msftngp13.phx.gbl...
> I have created a new DB user, ABC, for using ASP.NET application to
> connecting to SQL Server. Does it means this ABC user can logon in the
> Enterprise Manager to view the data without using the web application? if
> so, is there any way to block this ABC user from viewing data in
Enterprise
> Manager?
>