DISK IO Question

This may be a Really dumb Question, but I gotta ask it.
WHAT does the term IOPS "Really" Mean ?
I know, I Know...Input Output per second, but WHAT is an IO ?
The main issue is an IO 1byte, 1KB, 1 sector, or what ?
I need to estimate how long it's going to take to move 1GB of data from
Point A to B.
I intend to use DISK Specs of my 15k Drives to do this.
I estimate my drives to be capable of 128 IOPS.
so the golden question...128 WHAT ?
GAJ
Hi
There are so many factors that affect IO performance. OS cache, disk
controller cach, RAID levels etc.
IO/sec does not help. Look at Disk "external transfer rate" to get a good
idea.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"pdxJaxon" wrote:

> This may be a Really dumb Question, but I gotta ask it.
> WHAT does the term IOPS "Really" Mean ?
> I know, I Know...Input Output per second, but WHAT is an IO ?
> The main issue is an IO 1byte, 1KB, 1 sector, or what ?
> I need to estimate how long it's going to take to move 1GB of data from
> Point A to B.
> I intend to use DISK Specs of my 15k Drives to do this.
> I estimate my drives to be capable of 128 IOPS.
> so the golden question...128 WHAT ?
>
> GAJ
>
>
|||See Microsoft SQL Server 2000 Performance Tuning Technical Articles from
Microsoft Press.
Adrian
"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:uTWT4mUbFHA.2796@.tk2msftngp13.phx.gbl...
> This may be a Really dumb Question, but I gotta ask it.
> WHAT does the term IOPS "Really" Mean ?
> I know, I Know...Input Output per second, but WHAT is an IO ?
> The main issue is an IO 1byte, 1KB, 1 sector, or what ?
> I need to estimate how long it's going to take to move 1GB of data from
> Point A to B.
> I intend to use DISK Specs of my 15k Drives to do this.
> I estimate my drives to be capable of 128 IOPS.
> so the golden question...128 WHAT ?
>
> GAJ
>

DISK IO Question

This may be a Really dumb Question, but I gotta ask it.
WHAT does the term IOPS "Really" Mean ?
I know, I Know...Input Output per second, but WHAT is an IO ?
The main issue is an IO 1byte, 1KB, 1 sector, or what ?
I need to estimate how long it's going to take to move 1GB of data from
Point A to B.
I intend to use DISK Specs of my 15k Drives to do this.
I estimate my drives to be capable of 128 IOPS.
so the golden question...128 WHAT ?
GAJHi
There are so many factors that affect IO performance. OS cache, disk
controller cach, RAID levels etc.
IO/sec does not help. Look at Disk "external transfer rate" to get a good
idea.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"pdxJaxon" wrote:
> This may be a Really dumb Question, but I gotta ask it.
> WHAT does the term IOPS "Really" Mean ?
> I know, I Know...Input Output per second, but WHAT is an IO ?
> The main issue is an IO 1byte, 1KB, 1 sector, or what ?
> I need to estimate how long it's going to take to move 1GB of data from
> Point A to B.
> I intend to use DISK Specs of my 15k Drives to do this.
> I estimate my drives to be capable of 128 IOPS.
> so the golden question...128 WHAT ?
>
> GAJ
>
>|||See Microsoft SQL Server 2000 Performance Tuning Technical Articles from
Microsoft Press.
Adrian
"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:uTWT4mUbFHA.2796@.tk2msftngp13.phx.gbl...
> This may be a Really dumb Question, but I gotta ask it.
> WHAT does the term IOPS "Really" Mean ?
> I know, I Know...Input Output per second, but WHAT is an IO ?
> The main issue is an IO 1byte, 1KB, 1 sector, or what ?
> I need to estimate how long it's going to take to move 1GB of data from
> Point A to B.
> I intend to use DISK Specs of my 15k Drives to do this.
> I estimate my drives to be capable of 128 IOPS.
> so the golden question...128 WHAT ?
>
> GAJ
>sql

DISK IO Question

This may be a Really dumb Question, but I gotta ask it.
WHAT does the term IOPS "Really" Mean ?
I know, I Know...Input Output per second, but WHAT is an IO ?
The main issue is an IO 1byte, 1KB, 1 sector, or what ?
I need to estimate how long it's going to take to move 1GB of data from
Point A to B.
I intend to use DISK Specs of my 15k Drives to do this.
I estimate my drives to be capable of 128 IOPS.
so the golden question...128 WHAT ?
GAJHi
There are so many factors that affect IO performance. OS cache, disk
controller cach, RAID levels etc.
IO/sec does not help. Look at Disk "external transfer rate" to get a good
idea.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"pdxJaxon" wrote:

> This may be a Really dumb Question, but I gotta ask it.
> WHAT does the term IOPS "Really" Mean ?
> I know, I Know...Input Output per second, but WHAT is an IO ?
> The main issue is an IO 1byte, 1KB, 1 sector, or what ?
> I need to estimate how long it's going to take to move 1GB of data from
> Point A to B.
> I intend to use DISK Specs of my 15k Drives to do this.
> I estimate my drives to be capable of 128 IOPS.
> so the golden question...128 WHAT ?
>
> GAJ
>
>|||See Microsoft SQL Server 2000 Performance Tuning Technical Articles from
Microsoft Press.
Adrian
"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:uTWT4mUbFHA.2796@.tk2msftngp13.phx.gbl...
> This may be a Really dumb Question, but I gotta ask it.
> WHAT does the term IOPS "Really" Mean ?
> I know, I Know...Input Output per second, but WHAT is an IO ?
> The main issue is an IO 1byte, 1KB, 1 sector, or what ?
> I need to estimate how long it's going to take to move 1GB of data from
> Point A to B.
> I intend to use DISK Specs of my 15k Drives to do this.
> I estimate my drives to be capable of 128 IOPS.
> so the golden question...128 WHAT ?
>
> GAJ
>

Disabling One Input Parameter...?

Hi All,
I am creating a report which calls for four input parameters A, B, C, and D.
How can I disable D if A, B, and C are selected or disable C if A, B, and D
are selected?
Thx, ChuckThis is not supported. The only way to achieve this right now is to
implement your own front end application which handles the parameter UI and
then e.g. uses SOAP or URL-access to pass the "validated" parameters to the
report server.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chuck" <Chuck@.discussions.microsoft.com> wrote in message
news:32F07069-7C11-4608-9E86-68796ED25A99@.microsoft.com...
> Hi All,
> I am creating a report which calls for four input parameters A, B, C, and
> D.
> How can I disable D if A, B, and C are selected or disable C if A, B, and
> D
> are selected?
> Thx, Chuck|||Set a table up in your database called "NILL" with a column called "NILL"
as well. Use the from query section in the report parameters and create a
query which points to this table. Set your Non-queried Default value to
NILL.
Create a dataset for each report parameter. Some duplication, but is quick
and it works. Have done it for database table and columns names where one
or more can be selected and the column info is passed back as a results
alias and is returned independently of the other report parameters.
Eg. DBTableNames
Select Name, Id
From sysobjects where xtype ='U'And ID <> 197555541
Order by Name
DBTablesColNames relys on a tablename to be selected before the report will
allow the selection of a column
Select Name
From syscolumns
Where id = (Select Id
From sysobjects
Where xtype = 'U' AND Name = @.DBName)
** @.DBName = Parameters!TableParameter.Value **
I had to implement custom code in order for this to be of benefit.
Eg. Dataset CustomSQL
= Code.GetSQL(Parameters!TableParameter.Value, Parameters!
ColumnParameter.Value, Parameters!EndDate.Value, Parameters!Interval.Value,
Parameters!NoOfIntervals.Value)
As you can see from the dataset CustomSQL this is one of my so called
"Adhoc Reports" which allows the user to choose a database table and one of
its columns with a given date, an iterval (ie. Daily, Monthly etc), and the
No. of intevals. I have three tables on the report page that each call this
dataset passing in their own report parameters.
Note you have to manually set the name and database feild under "Fields" to
Results to get any data back

Disable auto mapping by matching column names?

Hi,

If you use a component that has a column mapping tab (most do) then you know that the component will try and map input and output columns automatically by name.

Is there a way to disable this feature when writing your own custom components? There is already a manual way to do this: rightmouse in the mappings tab of a component and chosen "Map Items By Matching Names". I find it is less helpful to auto-map initially because the designer tends to not think about the mappings.

A way of turning of auto-mapping in existing components would be cool too!

Cheers,

Martin

There is no way to turn it off currently You can easily remove all the mappings, though. This is the first request I hear for turning it off. Usually, people asked for additional smart mapping options.

Thanks,

Bob

|||

Bob,

Thanks for the reply. What I find is designers get lazy and don't question the auto-mapping. Then mistakes happen which they find hard to troubleshoot because their brains weren't involved in the mapping - it's not a step they try to replay as they look for problems.

Because it happens automatically when you switch to the map pane, I wonder if it's the SSIS equivalent of Clippy announcing your Word doc "looks like you're writing a letter" and reformatting it automatically without you getting a chance to say no! :-)

Further clever mapping options would be great, but I'd suggest the designer needs to make the conscious step of making it happen.

All the best,

Martin

Disable auto mapping by matching column names?

Hi,

If you use a component that has a column mapping tab (most do) then you know that the component will try and map input and output columns automatically by name.

Is there a way to disable this feature when writing your own custom components? There is already a manual way to do this: rightmouse in the mappings tab of a component and chosen "Map Items By Matching Names". I find it is less helpful to auto-map initially because the designer tends to not think about the mappings.

A way of turning of auto-mapping in existing components would be cool too!

Cheers,

Martin

There is no way to turn it off currently You can easily remove all the mappings, though. This is the first request I hear for turning it off. Usually, people asked for additional smart mapping options.

Thanks,

Bob

|||

Bob,

Thanks for the reply. What I find is designers get lazy and don't question the auto-mapping. Then mistakes happen which they find hard to troubleshoot because their brains weren't involved in the mapping - it's not a step they try to replay as they look for problems.

Because it happens automatically when you switch to the map pane, I wonder if it's the SSIS equivalent of Clippy announcing your Word doc "looks like you're writing a letter" and reformatting it automatically without you getting a chance to say no! :-)

Further clever mapping options would be great, but I'd suggest the designer needs to make the conscious step of making it happen.

All the best,

Martin