显示标签为“somebody”的博文。显示所有博文
显示标签为“somebody”的博文。显示所有博文

2012年3月20日星期二

BCP Out each result of a query in a saperate file

hi,

i am trying to BCP out the result of a query to a seperate file. i am trying to create a seperate file for each record. could somebody please help me out?

Pankaj

Do you really mean a seperate file for each row?
Or a separate file for each table?

If it's for each row, then how many rows are there?
..and why?

/Kenneth

|||

yes,

seperate file for each row. just trying to send file as per required by customer. by the way i am trying with CURSORS.

Pankaj

|||

Sorry for the late answer, it's busy times ;o)

It seems a very odd request from your customer...
In a query, how many rows are you expecting to do this on?

/Kenneth

2012年2月16日星期四

Batch Updates

Can somebody from Microsoft suggest a way to do batch updates from a stored
procedure ? I was considering OPENXML but it has a lot of memory related
problems so i need something where i can update/insert multiple rows without
making round trips to the server. Thanks!Did you look into the general Bulkload and BCP functionalities?
Is the data originally in XML or do you just consider XML as a potential
approach?
Best regards
Michael
"Vish" <Vish@.discussions.microsoft.com> wrote in message
news:CEF7CBCC-3AEE-4062-B491-560CF56729DC@.microsoft.com...
> Can somebody from Microsoft suggest a way to do batch updates from a
> stored
> procedure ? I was considering OPENXML but it has a lot of memory related
> problems so i need something where i can update/insert multiple rows
> without
> making round trips to the server. Thanks!|||Michael,
The data is originally in xml. I am doing realtime updates to the tables and
the xml is not very big. Moreover i have to span the updates in a
transaction. If there is a different approach than xml i can transform it to
a different format.
Thanks!
"Michael Rys [MSFT]" wrote:

> Did you look into the general Bulkload and BCP functionalities?
> Is the data originally in XML or do you just consider XML as a potential
> approach?
> Best regards
> Michael
> "Vish" <Vish@.discussions.microsoft.com> wrote in message
> news:CEF7CBCC-3AEE-4062-B491-560CF56729DC@.microsoft.com...
>
>|||If the XML is not very big the memory issues of OpenXML should not be
playing a big role.
You can however do one of the following for better perf:
1. Use the SQLXML Bulkload object.
2. Write some midtier code that decomposes your XML into either one of:
a Bulkload input file
b. A batch of T-SQL insert and update statements.
HTH
Michael
"Vish" <Vish@.discussions.microsoft.com> wrote in message
news:5818E367-1097-497F-9BD2-BACDE859450E@.microsoft.com...
> Michael,
> The data is originally in xml. I am doing realtime updates to the tables
> and
> the xml is not very big. Moreover i have to span the updates in a
> transaction. If there is a different approach than xml i can transform it
> to
> a different format.
> Thanks!
> "Michael Rys [MSFT]" wrote:
>|||Michael,
I already have the stored procedures to update the tables. Is there anyway i
can map the xml directly to stored proc parameters using transformation ?
Thanks!
"Michael Rys [MSFT]" wrote:

> If the XML is not very big the memory issues of OpenXML should not be
> playing a big role.
> You can however do one of the following for better perf:
> 1. Use the SQLXML Bulkload object.
> 2. Write some midtier code that decomposes your XML into either one of:
> a Bulkload input file
> b. A batch of T-SQL insert and update statements.
> HTH
> Michael
> "Vish" <Vish@.discussions.microsoft.com> wrote in message
> news:5818E367-1097-497F-9BD2-BACDE859450E@.microsoft.com...
>
>|||You will have to write mid-tier code to do so, I am afraid...
Best regards
Michael
"Vish" <Vish@.discussions.microsoft.com> wrote in message
news:39F52718-9899-4F67-BC91-4D6CF00415E4@.microsoft.com...
> Michael,
> I already have the stored procedures to update the tables. Is there anyway
> i
> can map the xml directly to stored proc parameters using transformation ?
> Thanks!
> "Michael Rys [MSFT]" wrote:
>|||Michael,
I know thats the easy way out but is there any other approach for sending
batch data to a stored procedure ? Looping in the application can be done bu
t
if i need to make it in a transaction is it a better idea to have the
transaction in the sproc or the outside in the code itself ?
Thanks!
"Michael Rys [MSFT]" wrote:

> You will have to write mid-tier code to do so, I am afraid...
> Best regards
> Michael
> "Vish" <Vish@.discussions.microsoft.com> wrote in message
> news:39F52718-9899-4F67-BC91-4D6CF00415E4@.microsoft.com...
>
>|||I don't think there is much of a difference whether you send multiple
invocations of the same sproc with different parameter values in a single
batch that is sent as a transaction or a stored proc that does it inside.
Again, there may be a benefit of using OpenXML inside a stored proc to do
your update expressions set-oriented under certain conditions instead of
generating your batch on the midtier and send a large batch to the server.
The easiest is to write a sample app to test the approaches with some of the
data to be used and using the same setup (to get the client-server comm cost
right).
Best regards
Michael
"Vish" <Vish@.discussions.microsoft.com> wrote in message
news:9F88DE36-35AA-4E6B-9DC5-B2EBD82CACF6@.microsoft.com...
> Michael,
> I know thats the easy way out but is there any other approach for sending
> batch data to a stored procedure ? Looping in the application can be done
> but
> if i need to make it in a transaction is it a better idea to have the
> transaction in the sproc or the outside in the code itself ?
> Thanks!
> "Michael Rys [MSFT]" wrote:
>

Batch Updates

Can somebody from Microsoft suggest a way to do batch updates from a stored
procedure ? I was considering OPENXML but it has a lot of memory related
problems so i need something where i can update/insert multiple rows without
making round trips to the server. Thanks!
Michael,
I already have the stored procedures to update the tables. Is there anyway i
can map the xml directly to stored proc parameters using transformation ?
Thanks!
"Michael Rys [MSFT]" wrote:

> If the XML is not very big the memory issues of OpenXML should not be
> playing a big role.
> You can however do one of the following for better perf:
> 1. Use the SQLXML Bulkload object.
> 2. Write some midtier code that decomposes your XML into either one of:
> a Bulkload input file
> b. A batch of T-SQL insert and update statements.
> HTH
> Michael
> "Vish" <Vish@.discussions.microsoft.com> wrote in message
> news:5818E367-1097-497F-9BD2-BACDE859450E@.microsoft.com...
>
>
|||You will have to write mid-tier code to do so, I am afraid...
Best regards
Michael
"Vish" <Vish@.discussions.microsoft.com> wrote in message
news:39F52718-9899-4F67-BC91-4D6CF00415E4@.microsoft.com...[vbcol=seagreen]
> Michael,
> I already have the stored procedures to update the tables. Is there anyway
> i
> can map the xml directly to stored proc parameters using transformation ?
> Thanks!
> "Michael Rys [MSFT]" wrote:
|||Michael,
I know thats the easy way out but is there any other approach for sending
batch data to a stored procedure ? Looping in the application can be done but
if i need to make it in a transaction is it a better idea to have the
transaction in the sproc or the outside in the code itself ?
Thanks!
"Michael Rys [MSFT]" wrote:

> You will have to write mid-tier code to do so, I am afraid...
> Best regards
> Michael
> "Vish" <Vish@.discussions.microsoft.com> wrote in message
> news:39F52718-9899-4F67-BC91-4D6CF00415E4@.microsoft.com...
>
>
|||I don't think there is much of a difference whether you send multiple
invocations of the same sproc with different parameter values in a single
batch that is sent as a transaction or a stored proc that does it inside.
Again, there may be a benefit of using OpenXML inside a stored proc to do
your update expressions set-oriented under certain conditions instead of
generating your batch on the midtier and send a large batch to the server.
The easiest is to write a sample app to test the approaches with some of the
data to be used and using the same setup (to get the client-server comm cost
right).
Best regards
Michael
"Vish" <Vish@.discussions.microsoft.com> wrote in message
news:9F88DE36-35AA-4E6B-9DC5-B2EBD82CACF6@.microsoft.com...[vbcol=seagreen]
> Michael,
> I know thats the easy way out but is there any other approach for sending
> batch data to a stored procedure ? Looping in the application can be done
> but
> if i need to make it in a transaction is it a better idea to have the
> transaction in the sproc or the outside in the code itself ?
> Thanks!
> "Michael Rys [MSFT]" wrote:
|||Did you look into the general Bulkload and BCP functionalities?
Is the data originally in XML or do you just consider XML as a potential
approach?
Best regards
Michael
"Vish" <Vish@.discussions.microsoft.com> wrote in message
news:CEF7CBCC-3AEE-4062-B491-560CF56729DC@.microsoft.com...
> Can somebody from Microsoft suggest a way to do batch updates from a
> stored
> procedure ? I was considering OPENXML but it has a lot of memory related
> problems so i need something where i can update/insert multiple rows
> without
> making round trips to the server. Thanks!
|||Michael,
The data is originally in xml. I am doing realtime updates to the tables and
the xml is not very big. Moreover i have to span the updates in a
transaction. If there is a different approach than xml i can transform it to
a different format.
Thanks!
"Michael Rys [MSFT]" wrote:

> Did you look into the general Bulkload and BCP functionalities?
> Is the data originally in XML or do you just consider XML as a potential
> approach?
> Best regards
> Michael
> "Vish" <Vish@.discussions.microsoft.com> wrote in message
> news:CEF7CBCC-3AEE-4062-B491-560CF56729DC@.microsoft.com...
>
>
|||If the XML is not very big the memory issues of OpenXML should not be
playing a big role.
You can however do one of the following for better perf:
1. Use the SQLXML Bulkload object.
2. Write some midtier code that decomposes your XML into either one of:
a Bulkload input file
b. A batch of T-SQL insert and update statements.
HTH
Michael
"Vish" <Vish@.discussions.microsoft.com> wrote in message
news:5818E367-1097-497F-9BD2-BACDE859450E@.microsoft.com...[vbcol=seagreen]
> Michael,
> The data is originally in xml. I am doing realtime updates to the tables
> and
> the xml is not very big. Moreover i have to span the updates in a
> transaction. If there is a different approach than xml i can transform it
> to
> a different format.
> Thanks!
> "Michael Rys [MSFT]" wrote:

Batch Requests/Sec counter

Hi,
I hope that somebody can help me to clarify for this.
Below is an excerpt extracted from the www.sql-server-performance.com website.
The batch requests per second shown on the performance monitor screen is in the scale of 1000.
My current server has 6 CPUs but with only 100mb network card. I'm a bit concern on the values shown for this particular counter which is average over 27243187 batch requests/Sec. Also lately the CPU utilization is also getting higher in the range of abov
e 80%. The question here is whether a network bottleneck in this can cause an increase in CPU utilization? if yes may I know why also?
Thanks
-debbie-
To get a feel of how busy SQL Server is, monitor the SQLServer: SQL Statistics: Batch Requests/Sec counter. This counter measures the number of batch requests that SQL Server receives per second, and generally follows in step to how busy your server's CPU
s are. Generally speaking, over 1000 batch requests per second indicates a very busy SQL Server, and could mean that if you are not already experiencing a CPU bottleneck, that you may very well soon. Of course, this is a relative number, and the bigger yo
ur hardware, the more batch requests per second SQL Server can handle.
From a network bottleneck approach, a typical 100Mbs network card is only able to handle about 3000 batch requests per second. If you have a server that is this busy, you may need to have two or more network cards, or go to a 1Gbs network card.
I find it hard to believe that your system is processing 27 million batch
requests per second<g>. Where are you getting the value from?
Andrew J. Kelly SQL MVP
"debcwong" <debcwong@.discussions.microsoft.com> wrote in message
news:92A9ACE5-072E-4DF4-822F-B5E23B669B49@.microsoft.com...
> Hi,
> I hope that somebody can help me to clarify for this.
> Below is an excerpt extracted from the www.sql-server-performance.com
website.
> The batch requests per second shown on the performance monitor screen is
in the scale of 1000.
> My current server has 6 CPUs but with only 100mb network card. I'm a bit
concern on the values shown for this particular counter which is average
over 27243187 batch requests/Sec. Also lately the CPU utilization is also
getting higher in the range of above 80%. The question here is whether a
network bottleneck in this can cause an increase in CPU utilization? if yes
may I know why also?
>
> Thanks
> -debbie-
> ----
--
> To get a feel of how busy SQL Server is, monitor the SQLServer: SQL
Statistics: Batch Requests/Sec counter. This counter measures the number of
batch requests that SQL Server receives per second, and generally follows in
step to how busy your server's CPUs are. Generally speaking, over 1000 batch
requests per second indicates a very busy SQL Server, and could mean that if
you are not already experiencing a CPU bottleneck, that you may very well
soon. Of course, this is a relative number, and the bigger your hardware,
the more batch requests per second SQL Server can handle.
> From a network bottleneck approach, a typical 100Mbs network card is only
able to handle about 3000 batch requests per second. If you have a server
that is this busy, you may need to have two or more network cards, or go to
a 1Gbs network card.
> ----
--
>
|||Sounds like you pulled the raw counters from sysperfinfo. Those are not
time-adjusted. See http://support.microsoft.com/?id=555064 for a short
explanation. You wil need to use the Performance Monitor tool to see the
actual per/second values.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"debcwong" <debcwong@.discussions.microsoft.com> wrote in message
news:92A9ACE5-072E-4DF4-822F-B5E23B669B49@.microsoft.com...
> Hi,
> I hope that somebody can help me to clarify for this.
> Below is an excerpt extracted from the www.sql-server-performance.com
website.
> The batch requests per second shown on the performance monitor screen is
in the scale of 1000.
> My current server has 6 CPUs but with only 100mb network card. I'm a bit
concern on the values shown for this particular counter which is average
over 27243187 batch requests/Sec. Also lately the CPU utilization is also
getting higher in the range of above 80%. The question here is whether a
network bottleneck in this can cause an increase in CPU utilization? if yes
may I know why also?
>
> Thanks
> -debbie-
> ----
--
> To get a feel of how busy SQL Server is, monitor the SQLServer: SQL
Statistics: Batch Requests/Sec counter. This counter measures the number of
batch requests that SQL Server receives per second, and generally follows in
step to how busy your server's CPUs are. Generally speaking, over 1000 batch
requests per second indicates a very busy SQL Server, and could mean that if
you are not already experiencing a CPU bottleneck, that you may very well
soon. Of course, this is a relative number, and the bigger your hardware,
the more batch requests per second SQL Server can handle.
> From a network bottleneck approach, a typical 100Mbs network card is only
able to handle about 3000 batch requests per second. If you have a server
that is this busy, you may need to have two or more network cards, or go to
a 1Gbs network card.
> ----
--
>
|||The performance monitor shows it at the scale of 1000 so
after you times it it's around the same value as
sysperfinfo. So I guess that I shouldn't times the scale?

>--Original Message--
>Sounds like you pulled the raw counters from
sysperfinfo. Those are not
>time-adjusted. See http://support.microsoft.com/?
id=555064 for a short
>explanation. You wil need to use the Performance
Monitor tool to see the
>actual per/second values.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"debcwong" <debcwong@.discussions.microsoft.com> wrote in
message
>news:92A9ACE5-072E-4DF4-822F-
B5E23B669B49@.microsoft.com...[vbcol=seagreen]
performance.com[vbcol=seagreen]
>website.
monitor screen is[vbcol=seagreen]
>in the scale of 1000.
network card. I'm a bit
>concern on the values shown for this particular counter
which is average
>over 27243187 batch requests/Sec. Also lately the CPU
utilization is also
>getting higher in the range of above 80%. The question
here is whether a
>network bottleneck in this can cause an increase in CPU
utilization? if yes[vbcol=seagreen]
>may I know why also?
--[vbcol=seagreen]
>--
SQLServer: SQL
>Statistics: Batch Requests/Sec counter. This counter
measures the number of
>batch requests that SQL Server receives per second, and
generally follows in
>step to how busy your server's CPUs are. Generally
speaking, over 1000 batch
>requests per second indicates a very busy SQL Server,
and could mean that if
>you are not already experiencing a CPU bottleneck, that
you may very well
>soon. Of course, this is a relative number, and the
bigger your hardware,[vbcol=seagreen]
>the more batch requests per second SQL Server can handle.
network card is only
>able to handle about 3000 batch requests per second. If
you have a server
>that is this busy, you may need to have two or more
network cards, or go to[vbcol=seagreen]
>a 1Gbs network card.
--
>--
>
>.
>
|||The scale on performance monitor only affects the position of the graph.
The counter value should be the correct number.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:240a801c45f46$fb515f60$a301280a@.phx.gbl...[vbcol=seagreen]
> The performance monitor shows it at the scale of 1000 so
> after you times it it's around the same value as
> sysperfinfo. So I guess that I shouldn't times the scale?
> sysperfinfo. Those are not
> id=555064 for a short
> Monitor tool to see the
> message
> B5E23B669B49@.microsoft.com...
> performance.com
> monitor screen is
> network card. I'm a bit
> which is average
> utilization is also
> here is whether a
> utilization? if yes
> --
> SQLServer: SQL
> measures the number of
> generally follows in
> speaking, over 1000 batch
> and could mean that if
> you may very well
> bigger your hardware,
> network card is only
> you have a server
> network cards, or go to
> --
|||hmm... the scale of the graph is the same as the counter
but the scale in the column beneath it is 1000...
sorry... very confusing to me.

>--Original Message--
>The scale on performance monitor only affects the
position of the graph.[vbcol=seagreen]
>The counter value should be the correct number.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
><anonymous@.discussions.microsoft.com> wrote in message
>news:240a801c45f46$fb515f60$a301280a@.phx.gbl...
so[vbcol=seagreen]
scale?[vbcol=seagreen]
in[vbcol=seagreen]
this.[vbcol=seagreen]
server-[vbcol=seagreen]
performance[vbcol=seagreen]
counter[vbcol=seagreen]
CPU[vbcol=seagreen]
--[vbcol=seagreen]
and[vbcol=seagreen]
that[vbcol=seagreen]
handle.[vbcol=seagreen]
If[vbcol=seagreen]
--
>
>.
>
|||It's easier to see the actual values in the Report mode vs. the graph mode
or Perfmon.
Andrew J. Kelly SQL MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:2466001c45fca$da3d27d0$a601280a@.phx.gbl...[vbcol=seagreen]
> hmm... the scale of the graph is the same as the counter
> but the scale in the column beneath it is 1000...
> sorry... very confusing to me.
> position of the graph.
> so
> scale?
> in
> this.
> server-
> performance
> counter
> CPU
> --
> and
> that
> handle.
> If
> --

Batch Requests/Sec counter

Hi,
I hope that somebody can help me to clarify for this.
Below is an excerpt extracted from the www.sql-server-performance.com websit
e.
The batch requests per second shown on the performance monitor screen is in
the scale of 1000.
My current server has 6 CPUs but with only 100mb network card. I'm a bit con
cern on the values shown for this particular counter which is average over 2
7243187 batch requests/Sec. Also lately the CPU utilization is also getting
higher in the range of abov
e 80%. The question here is whether a network bottleneck in this can cause a
n increase in CPU utilization? if yes may I know why also?
Thanks
-debbie-
----
--
To get a feel of how busy SQL Server is, monitor the SQLServer: SQL Statisti
cs: Batch Requests/Sec counter. This counter measures the number of batch re
quests that SQL Server receives per second, and generally follows in step to
how busy your server's CPU
s are. Generally speaking, over 1000 batch requests per second indicates a v
ery busy SQL Server, and could mean that if you are not already experiencing
a CPU bottleneck, that you may very well soon. Of course, this is a relativ
e number, and the bigger yo
ur hardware, the more batch requests per second SQL Server can handle.
From a network bottleneck approach, a typical 100Mbs network card is only ab
le to handle about 3000 batch requests per second. If you have a server that
is this busy, you may need to have two or more network cards, or go to a 1G
bs network card.
----
--I find it hard to believe that your system is processing 27 million batch
requests per second<g>. Where are you getting the value from?
Andrew J. Kelly SQL MVP
"debcwong" <debcwong@.discussions.microsoft.com> wrote in message
news:92A9ACE5-072E-4DF4-822F-B5E23B669B49@.microsoft.com...
> Hi,
> I hope that somebody can help me to clarify for this.
> Below is an excerpt extracted from the www.sql-server-performance.com
website.
> The batch requests per second shown on the performance monitor screen is
in the scale of 1000.
> My current server has 6 CPUs but with only 100mb network card. I'm a bit
concern on the values shown for this particular counter which is average
over 27243187 batch requests/Sec. Also lately the CPU utilization is also
getting higher in the range of above 80%. The question here is whether a
network bottleneck in this can cause an increase in CPU utilization? if yes
may I know why also?
>
> Thanks
> -debbie-
> ----
--
> To get a feel of how busy SQL Server is, monitor the SQLServer: SQL
Statistics: Batch Requests/Sec counter. This counter measures the number of
batch requests that SQL Server receives per second, and generally follows in
step to how busy your server's CPUs are. Generally speaking, over 1000 batch
requests per second indicates a very busy SQL Server, and could mean that if
you are not already experiencing a CPU bottleneck, that you may very well
soon. Of course, this is a relative number, and the bigger your hardware,
the more batch requests per second SQL Server can handle.
> From a network bottleneck approach, a typical 100Mbs network card is only
able to handle about 3000 batch requests per second. If you have a server
that is this busy, you may need to have two or more network cards, or go to
a 1Gbs network card.
> ----
--
>|||Sounds like you pulled the raw counters from sysperfinfo. Those are not
time-adjusted. See http://support.microsoft.com/?id=555064 for a short
explanation. You wil need to use the Performance Monitor tool to see the
actual per/second values.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"debcwong" <debcwong@.discussions.microsoft.com> wrote in message
news:92A9ACE5-072E-4DF4-822F-B5E23B669B49@.microsoft.com...
> Hi,
> I hope that somebody can help me to clarify for this.
> Below is an excerpt extracted from the www.sql-server-performance.com
website.
> The batch requests per second shown on the performance monitor screen is
in the scale of 1000.
> My current server has 6 CPUs but with only 100mb network card. I'm a bit
concern on the values shown for this particular counter which is average
over 27243187 batch requests/Sec. Also lately the CPU utilization is also
getting higher in the range of above 80%. The question here is whether a
network bottleneck in this can cause an increase in CPU utilization? if yes
may I know why also?
>
> Thanks
> -debbie-
> ----
--
> To get a feel of how busy SQL Server is, monitor the SQLServer: SQL
Statistics: Batch Requests/Sec counter. This counter measures the number of
batch requests that SQL Server receives per second, and generally follows in
step to how busy your server's CPUs are. Generally speaking, over 1000 batch
requests per second indicates a very busy SQL Server, and could mean that if
you are not already experiencing a CPU bottleneck, that you may very well
soon. Of course, this is a relative number, and the bigger your hardware,
the more batch requests per second SQL Server can handle.
> From a network bottleneck approach, a typical 100Mbs network card is only
able to handle about 3000 batch requests per second. If you have a server
that is this busy, you may need to have two or more network cards, or go to
a 1Gbs network card.
> ----
--
>|||The performance monitor shows it at the scale of 1000 so
after you times it it's around the same value as
sysperfinfo. So I guess that I shouldn't times the scale?

>--Original Message--
>Sounds like you pulled the raw counters from
sysperfinfo. Those are not
>time-adjusted. See http://support.microsoft.com/?
id=555064 for a short
>explanation. You wil need to use the Performance
Monitor tool to see the
>actual per/second values.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"debcwong" <debcwong@.discussions.microsoft.com> wrote in
message
>news:92A9ACE5-072E-4DF4-822F-
B5E23B669B49@.microsoft.com...
performance.com[vbcol=seagreen]
>website.
monitor screen is[vbcol=seagreen]
>in the scale of 1000.
network card. I'm a bit[vbcol=seagreen]
>concern on the values shown for this particular counter
which is average
>over 27243187 batch requests/Sec. Also lately the CPU
utilization is also
>getting higher in the range of above 80%. The question
here is whether a
>network bottleneck in this can cause an increase in CPU
utilization? if yes
>may I know why also?
--[vbcol=seagreen]
>--
SQLServer: SQL[vbcol=seagreen]
>Statistics: Batch Requests/Sec counter. This counter
measures the number of
>batch requests that SQL Server receives per second, and
generally follows in
>step to how busy your server's CPUs are. Generally
speaking, over 1000 batch
>requests per second indicates a very busy SQL Server,
and could mean that if
>you are not already experiencing a CPU bottleneck, that
you may very well
>soon. Of course, this is a relative number, and the
bigger your hardware,
>the more batch requests per second SQL Server can handle.
network card is only[vbcol=seagreen]
>able to handle about 3000 batch requests per second. If
you have a server
>that is this busy, you may need to have two or more
network cards, or go to
>a 1Gbs network card.
--[vbcol=seagreen]
>--
>
>.
>|||The scale on performance monitor only affects the position of the graph.
The counter value should be the correct number.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:240a801c45f46$fb515f60$a301280a@.phx
.gbl...[vbcol=seagreen]
> The performance monitor shows it at the scale of 1000 so
> after you times it it's around the same value as
> sysperfinfo. So I guess that I shouldn't times the scale?
>
> sysperfinfo. Those are not
> id=555064 for a short
> Monitor tool to see the
> message
> B5E23B669B49@.microsoft.com...
> performance.com
> monitor screen is
> network card. I'm a bit
> which is average
> utilization is also
> here is whether a
> utilization? if yes
> --
> SQLServer: SQL
> measures the number of
> generally follows in
> speaking, over 1000 batch
> and could mean that if
> you may very well
> bigger your hardware,
> network card is only
> you have a server
> network cards, or go to
> --|||hmm... the scale of the graph is the same as the counter
but the scale in the column beneath it is 1000...
sorry... very confusing to me.

>--Original Message--
>The scale on performance monitor only affects the
position of the graph.
>The counter value should be the correct number.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
><anonymous@.discussions.microsoft.com> wrote in message
> news:240a801c45f46$fb515f60$a301280a@.phx
.gbl...
so[vbcol=seagreen]
scale?[vbcol=seagreen]
in[vbcol=seagreen]
this.[vbcol=seagreen]
server-[vbcol=seagreen]
performance[vbcol=seagreen]
counter[vbcol=seagreen]
CPU[vbcol=seagreen]
--[vbcol=seagreen]
and[vbcol=seagreen]
that[vbcol=seagreen]
handle.[vbcol=seagreen]
If[vbcol=seagreen]
--[vbcol=seagreen]
>
>.
>|||It's easier to see the actual values in the Report mode vs. the graph mode
or Perfmon.
Andrew J. Kelly SQL MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:2466001c45fca$da3d27d0$a601280a@.phx
.gbl...[vbcol=seagreen]
> hmm... the scale of the graph is the same as the counter
> but the scale in the column beneath it is 1000...
> sorry... very confusing to me.
>
> position of the graph.
> so
> scale?
> in
> this.
> server-
> performance
> counter
> CPU
> --
> and
> that
> handle.
> If
> --