a question about sp_monitor

On the Books Online for sp_monitor:
total_read Number of reads by SQL Server.
total_write Number of writes by SQL Server.
Can anybody explain what is Number of Reads/Writes mean? Is it the number of
bytes read/Write?
Thanks,
LijunThey are same as @.@.total_read (or @.@.total_write), and they are the total
number of disk reads (or writes) by SQL Server since it starts. So they are
definitely not the number of bytes read or written.
I don't use sp_monitor, and I don't know anybody who uses sp_monitor for any
sort of practical performance tuning or troubleshooting purposes.
Linchi
"Lijun Zhang" wrote:

> On the Books Online for sp_monitor:
> total_read Number of reads by SQL Server.
> total_write Number of writes by SQL Server.
>
> Can anybody explain what is Number of Reads/Writes mean? Is it the number
of
> bytes read/Write?
> Thanks,
> Lijun
>
>|||Thanks, Linchi. What I am trying to do is to get number of bytes read/write
for a period of time. We are looking at buy a new server to replace one of
the production servers, and I am trying to get the bandwidth requirements.
Do you know how to get the counters? Is System Monitor the only tool I can
use?
Lijun
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:4E872DCB-ADB7-4CFD-85FB-44F4A73035F7@.microsoft.com...[vbcol=seagreen]
> They are same as @.@.total_read (or @.@.total_write), and they are the total
> number of disk reads (or writes) by SQL Server since it starts. So they
> are
> definitely not the number of bytes read or written.
> I don't use sp_monitor, and I don't know anybody who uses sp_monitor for
> any
> sort of practical performance tuning or troubleshooting purposes.
> Linchi
> "Lijun Zhang" wrote:
>|||That won't tell you any kind of bandwidth. Exactly what are you trying to
determine the server or the storage?
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Lijun Zhang" <sonyzhang00@.yahoo.com> wrote in message
news:e%23ndhA8SIHA.2000@.TK2MSFTNGP05.phx.gbl...
> Thanks, Linchi. What I am trying to do is to get number of bytes
> read/write for a period of time. We are looking at buy a new server to
> replace one of the production servers, and I am trying to get the
> bandwidth requirements.
> Do you know how to get the counters? Is System Monitor the only tool I can
> use?
> Lijun
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:4E872DCB-ADB7-4CFD-85FB-44F4A73035F7@.microsoft.com...
>

a question about sp_monitor

On the Books Online for sp_monitor:
total_read Number of reads by SQL Server.
total_write Number of writes by SQL Server.
Can anybody explain what is Number of Reads/Writes mean? Is it the number of
bytes read/Write?
Thanks,
Lijun
They are same as @.@.total_read (or @.@.total_write), and they are the total
number of disk reads (or writes) by SQL Server since it starts. So they are
definitely not the number of bytes read or written.
I don't use sp_monitor, and I don't know anybody who uses sp_monitor for any
sort of practical performance tuning or troubleshooting purposes.
Linchi
"Lijun Zhang" wrote:

> On the Books Online for sp_monitor:
> total_read Number of reads by SQL Server.
> total_write Number of writes by SQL Server.
>
> Can anybody explain what is Number of Reads/Writes mean? Is it the number of
> bytes read/Write?
> Thanks,
> Lijun
>
>
|||Thanks, Linchi. What I am trying to do is to get number of bytes read/write
for a period of time. We are looking at buy a new server to replace one of
the production servers, and I am trying to get the bandwidth requirements.
Do you know how to get the counters? Is System Monitor the only tool I can
use?
Lijun
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:4E872DCB-ADB7-4CFD-85FB-44F4A73035F7@.microsoft.com...[vbcol=seagreen]
> They are same as @.@.total_read (or @.@.total_write), and they are the total
> number of disk reads (or writes) by SQL Server since it starts. So they
> are
> definitely not the number of bytes read or written.
> I don't use sp_monitor, and I don't know anybody who uses sp_monitor for
> any
> sort of practical performance tuning or troubleshooting purposes.
> Linchi
> "Lijun Zhang" wrote:
|||That won't tell you any kind of bandwidth. Exactly what are you trying to
determine the server or the storage?
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Lijun Zhang" <sonyzhang00@.yahoo.com> wrote in message
news:e%23ndhA8SIHA.2000@.TK2MSFTNGP05.phx.gbl...
> Thanks, Linchi. What I am trying to do is to get number of bytes
> read/write for a period of time. We are looking at buy a new server to
> replace one of the production servers, and I am trying to get the
> bandwidth requirements.
> Do you know how to get the counters? Is System Monitor the only tool I can
> use?
> Lijun
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:4E872DCB-ADB7-4CFD-85FB-44F4A73035F7@.microsoft.com...
>

a question about sp_monitor

On the Books Online for sp_monitor:
total_read Number of reads by SQL Server.
total_write Number of writes by SQL Server.
Can anybody explain what is Number of Reads/Writes mean? Is it the number of
bytes read/Write?
Thanks,
LijunThey are same as @.@.total_read (or @.@.total_write), and they are the total
number of disk reads (or writes) by SQL Server since it starts. So they are
definitely not the number of bytes read or written.
I don't use sp_monitor, and I don't know anybody who uses sp_monitor for any
sort of practical performance tuning or troubleshooting purposes.
Linchi
"Lijun Zhang" wrote:
> On the Books Online for sp_monitor:
> total_read Number of reads by SQL Server.
> total_write Number of writes by SQL Server.
>
> Can anybody explain what is Number of Reads/Writes mean? Is it the number of
> bytes read/Write?
> Thanks,
> Lijun
>
>|||Thanks, Linchi. What I am trying to do is to get number of bytes read/write
for a period of time. We are looking at buy a new server to replace one of
the production servers, and I am trying to get the bandwidth requirements.
Do you know how to get the counters? Is System Monitor the only tool I can
use?
Lijun
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:4E872DCB-ADB7-4CFD-85FB-44F4A73035F7@.microsoft.com...
> They are same as @.@.total_read (or @.@.total_write), and they are the total
> number of disk reads (or writes) by SQL Server since it starts. So they
> are
> definitely not the number of bytes read or written.
> I don't use sp_monitor, and I don't know anybody who uses sp_monitor for
> any
> sort of practical performance tuning or troubleshooting purposes.
> Linchi
> "Lijun Zhang" wrote:
>> On the Books Online for sp_monitor:
>> total_read Number of reads by SQL Server.
>> total_write Number of writes by SQL Server.
>>
>> Can anybody explain what is Number of Reads/Writes mean? Is it the number
>> of
>> bytes read/Write?
>> Thanks,
>> Lijun
>>|||That won't tell you any kind of bandwidth. Exactly what are you trying to
determine the server or the storage?
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Lijun Zhang" <sonyzhang00@.yahoo.com> wrote in message
news:e%23ndhA8SIHA.2000@.TK2MSFTNGP05.phx.gbl...
> Thanks, Linchi. What I am trying to do is to get number of bytes
> read/write for a period of time. We are looking at buy a new server to
> replace one of the production servers, and I am trying to get the
> bandwidth requirements.
> Do you know how to get the counters? Is System Monitor the only tool I can
> use?
> Lijun
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:4E872DCB-ADB7-4CFD-85FB-44F4A73035F7@.microsoft.com...
>> They are same as @.@.total_read (or @.@.total_write), and they are the total
>> number of disk reads (or writes) by SQL Server since it starts. So they
>> are
>> definitely not the number of bytes read or written.
>> I don't use sp_monitor, and I don't know anybody who uses sp_monitor for
>> any
>> sort of practical performance tuning or troubleshooting purposes.
>> Linchi
>> "Lijun Zhang" wrote:
>> On the Books Online for sp_monitor:
>> total_read Number of reads by SQL Server.
>> total_write Number of writes by SQL Server.
>>
>> Can anybody explain what is Number of Reads/Writes mean? Is it the
>> number of
>> bytes read/Write?
>> Thanks,
>> Lijun
>>
>

A question about association rules

Hi

I am doing the Market basket analysis for a retailer using association rule. The whole data set is huge which contains grocery, clothes and books etc. If I want to check out the relationship between several different clothes brands, (e.g. LEVI'S and adidas), should I just remove all the grocery and books transactions, use the subset which only contains clothes transactions to re-run the association rules? Is this gonna work?

Thanks in advance!

You can create differents data source views (dsv) as a support for a model desired. For the dsv you can build the apropriate view in SQL Server that select that several different clothes brands (in WHERE clause). You don't have to remove any transaction.

Gigi Ciubuc

www.sqlserver.ro

|||Great help, thanks a lot.