This is a multi-part message in MIME format.
--=_NextPart_000_0011_01C5191B.23066440
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi all.
I've got a SQL Server 2k sp3 on Win 2003.
It has the Performance Counters listed for SQL Server, but when I select = any of the counters, they don't show any activity.
Any ideas?
Thanks,
Rick
--=_NextPart_000_0011_01C5191B.23066440
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi all.
I've got a SQL Server 2k sp3 on Win = 2003.
It has the Performance Counters listed for SQL = Server, but when I select any of the counters, they don't show any activity.
Any ideas?
Thanks,
Rick
--=_NextPart_000_0011_01C5191B.23066440--Hi
You may want to check your event logs to see if anything is being
logged.
Check sysperfinfo to see what information is there.
Rebuild the performance counters:
http://support.microsoft.com/default.aspx?scid=kb;en-us;300956
John|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1109147319.860891.81450@.f14g2000cwb.googlegroups.com...
> Hi
> You may want to check your event logs to see if anything is being
> logged.
> Check sysperfinfo to see what information is there.
> Rebuild the performance counters:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;300956
> John
>
Okay... nothing in the sysperinfo table. That would explain why the
counters are reading 0. I'm still trying to track down the problems
though. I will try the rebuild later today and see what happens.
Ricksql
Showing posts with label text. Show all posts
Showing posts with label text. Show all posts
Friday, March 23, 2012
Performance Counter Problems
Hi,
We are running SQL Server 2000 SP3a on Windows 2003 Server.
I use the Performance Log to capture some performance counters and saved
as text file. When I opened the captured file, I discovered that the
SQLServer Counters are not recording anything (\SQLServer:Memory
manager, \SQLServer:Buffer manager, etc ) But other counters like
\Physical Disk: %Disk Time, \Processor:%Processor Time are recording
values.
I will appreciate your help.
Thanks
Egbon
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!"Egbon V." <vnjowusi@.gosps.com> wrote in message
news:eXySJtO7DHA.2656@.TK2MSFTNGP11.phx.gbl...
> We are running SQL Server 2000 SP3a on Windows 2003 Server.
> I use the Performance Log to capture some performance counters and saved
> as text file. When I opened the captured file, I discovered that the
> SQLServer Counters are not recording anything (\SQLServer:Memory
> manager, \SQLServer:Buffer manager, etc ) But other counters like
> \Physical Disk: %Disk Time, \Processor:%Processor Time are recording
> values.
This article looks promising, it may be a WMI registration issue:
http://support.microsoft.com/defaul...0&Product=sql2k
Steve|||Steve,
Thanks a lot!
Egbon
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!sql
We are running SQL Server 2000 SP3a on Windows 2003 Server.
I use the Performance Log to capture some performance counters and saved
as text file. When I opened the captured file, I discovered that the
SQLServer Counters are not recording anything (\SQLServer:Memory
manager, \SQLServer:Buffer manager, etc ) But other counters like
\Physical Disk: %Disk Time, \Processor:%Processor Time are recording
values.
I will appreciate your help.
Thanks
Egbon
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!"Egbon V." <vnjowusi@.gosps.com> wrote in message
news:eXySJtO7DHA.2656@.TK2MSFTNGP11.phx.gbl...
> We are running SQL Server 2000 SP3a on Windows 2003 Server.
> I use the Performance Log to capture some performance counters and saved
> as text file. When I opened the captured file, I discovered that the
> SQLServer Counters are not recording anything (\SQLServer:Memory
> manager, \SQLServer:Buffer manager, etc ) But other counters like
> \Physical Disk: %Disk Time, \Processor:%Processor Time are recording
> values.
This article looks promising, it may be a WMI registration issue:
http://support.microsoft.com/defaul...0&Product=sql2k
Steve|||Steve,
Thanks a lot!
Egbon
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!sql
Performance Counter Problems
Hi,
We are running SQL Server 2000 SP3a on Windows 2003 Server.
I use the Performance Log to capture some performance counters and saved
as text file. When I opened the captured file, I discovered that the
SQLServer Counters are not recording anything (\SQLServer:Memory
manager, \SQLServer:Buffer manager, etc ) But other counters like
\Physical Disk: %Disk Time, \Processor:%Processor Time are recording
values.
I will appreciate your help.
Thanks
Egbon
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!"Egbon V." <vnjowusi@.gosps.com> wrote in message
news:eXySJtO7DHA.2656@.TK2MSFTNGP11.phx.gbl...
> We are running SQL Server 2000 SP3a on Windows 2003 Server.
> I use the Performance Log to capture some performance counters and saved
> as text file. When I opened the captured file, I discovered that the
> SQLServer Counters are not recording anything (\SQLServer:Memory
> manager, \SQLServer:Buffer manager, etc ) But other counters like
> \Physical Disk: %Disk Time, \Processor:%Processor Time are recording
> values.
This article looks promising, it may be a WMI registration issue:
http://support.microsoft.com/default.aspx?scid=kb;en-us;827260&Product=sql2k
Steve
We are running SQL Server 2000 SP3a on Windows 2003 Server.
I use the Performance Log to capture some performance counters and saved
as text file. When I opened the captured file, I discovered that the
SQLServer Counters are not recording anything (\SQLServer:Memory
manager, \SQLServer:Buffer manager, etc ) But other counters like
\Physical Disk: %Disk Time, \Processor:%Processor Time are recording
values.
I will appreciate your help.
Thanks
Egbon
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!"Egbon V." <vnjowusi@.gosps.com> wrote in message
news:eXySJtO7DHA.2656@.TK2MSFTNGP11.phx.gbl...
> We are running SQL Server 2000 SP3a on Windows 2003 Server.
> I use the Performance Log to capture some performance counters and saved
> as text file. When I opened the captured file, I discovered that the
> SQLServer Counters are not recording anything (\SQLServer:Memory
> manager, \SQLServer:Buffer manager, etc ) But other counters like
> \Physical Disk: %Disk Time, \Processor:%Processor Time are recording
> values.
This article looks promising, it may be a WMI registration issue:
http://support.microsoft.com/default.aspx?scid=kb;en-us;827260&Product=sql2k
Steve
Monday, February 20, 2012
Percentages are rounding and I don't want them to
Using SQLRS 2005
No matter how I format the percentage (using FormatPercent or "P" format
option, my text box in a table control rounds the percentage to a whole
percentage with zeroes in the decimal columns.
I don't want it to round off at all.
Any pointers?
--
John ShahanOn Jan 31, 12:49 pm, jp <j...@.discussions.microsoft.com> wrote:
> Using SQLRS 2005
> No matter how I format the percentage (using FormatPercent or "P" format
> option, my text box in a table control rounds the percentage to a whole
> percentage with zeroes in the decimal columns.
> I don't want it to round off at all.
> Any pointers?
> --
> John Shahan
I am not sure this will help but...
Leave the formatting alone and just use the expression builder
In database column (lets call is percentField), number is like this...
123.456789 then in expression builder '=Fields!percentField.Value +
"%" ' - field should look like 123.456789% on the report.
.123456789 then in expression builder '=(Fields!percentField.Value
*100) + "%" ' - field should look like 123.456789% on the report.
I hope that is what you were talking about and I hope that helps you.
Thanks and have a great day,
Kerrie|||Thank you very much for taking the time to respond.
I tried eliminating the formating as you suggested. And I now have
=Fields!JulPercentage.Value * 100 & "%" as the expression but it is still
taking a value like .026436346 (confirmed by looking at the result set in the
Data tab) and making it 3.00% in the table control on the report.
--
John Shahan
"Kerrie" wrote:
> On Jan 31, 12:49 pm, jp <j...@.discussions.microsoft.com> wrote:
> > Using SQLRS 2005
> > No matter how I format the percentage (using FormatPercent or "P" format
> > option, my text box in a table control rounds the percentage to a whole
> > percentage with zeroes in the decimal columns.
> >
> > I don't want it to round off at all.
> >
> > Any pointers?
> > --
> > John Shahan
> I am not sure this will help but...
> Leave the formatting alone and just use the expression builder
> In database column (lets call is percentField), number is like this...
> 123.456789 then in expression builder '=Fields!percentField.Value +
> "%" ' - field should look like 123.456789% on the report.
> ..123456789 then in expression builder '=(Fields!percentField.Value
> *100) + "%" ' - field should look like 123.456789% on the report.
> I hope that is what you were talking about and I hope that helps you.
> Thanks and have a great day,
> Kerrie
>|||On Feb 1, 4:49 am, jp <j...@.discussions.microsoft.com> wrote:
> Using SQLRS 2005
> No matter how I format the percentage (using FormatPercent or "P" format
> option, my text box in a table control rounds the percentage to a whole
> percentage with zeroes in the decimal columns.
> I don't want it to round off at all.
> Any pointers?
> --
> John Shahan
You can specify the number of decimal places you would like to see in
the percentage, using the
FormatPercent(number, DecimalPlaces) function. However, this will show
zeros if the percent is a whole number. If you want sometimes to show
decimal places, but to show no trailing zeros, then you probably need
to construct the number manually (division, then multiply by 100) and
add the % sign on the end as a string.
Rowen|||On Jan 31, 6:33 pm, "Rowen" <rowen...@.gmail.com> wrote:
> On Feb 1, 4:49 am, jp <j...@.discussions.microsoft.com> wrote:
> > Using SQLRS 2005
> > No matter how I format the percentage (using FormatPercent or "P" format
> > option, my text box in a table control rounds the percentage to a whole
> > percentage with zeroes in the decimal columns.
> > I don't want it to round off at all.
> > Any pointers?
> > --
> > John Shahan
> You can specify the number of decimal places you would like to see in
> the percentage, using the
> FormatPercent(number, DecimalPlaces) function. However, this will show
> zeros if the percent is a whole number. If you want sometimes to show
> decimal places, but to show no trailing zeros, then you probably need
> to construct the number manually (division, then multiply by 100) and
> add the % sign on the end as a string.
> Rowen
I would definitly try Rowan's suggestions, but what do you have the
format as on the table for that field? Something is set and it needs
to be turned off. I would leave it on 'General' or 'g' on the format
property.
Kerrie
No matter how I format the percentage (using FormatPercent or "P" format
option, my text box in a table control rounds the percentage to a whole
percentage with zeroes in the decimal columns.
I don't want it to round off at all.
Any pointers?
--
John ShahanOn Jan 31, 12:49 pm, jp <j...@.discussions.microsoft.com> wrote:
> Using SQLRS 2005
> No matter how I format the percentage (using FormatPercent or "P" format
> option, my text box in a table control rounds the percentage to a whole
> percentage with zeroes in the decimal columns.
> I don't want it to round off at all.
> Any pointers?
> --
> John Shahan
I am not sure this will help but...
Leave the formatting alone and just use the expression builder
In database column (lets call is percentField), number is like this...
123.456789 then in expression builder '=Fields!percentField.Value +
"%" ' - field should look like 123.456789% on the report.
.123456789 then in expression builder '=(Fields!percentField.Value
*100) + "%" ' - field should look like 123.456789% on the report.
I hope that is what you were talking about and I hope that helps you.
Thanks and have a great day,
Kerrie|||Thank you very much for taking the time to respond.
I tried eliminating the formating as you suggested. And I now have
=Fields!JulPercentage.Value * 100 & "%" as the expression but it is still
taking a value like .026436346 (confirmed by looking at the result set in the
Data tab) and making it 3.00% in the table control on the report.
--
John Shahan
"Kerrie" wrote:
> On Jan 31, 12:49 pm, jp <j...@.discussions.microsoft.com> wrote:
> > Using SQLRS 2005
> > No matter how I format the percentage (using FormatPercent or "P" format
> > option, my text box in a table control rounds the percentage to a whole
> > percentage with zeroes in the decimal columns.
> >
> > I don't want it to round off at all.
> >
> > Any pointers?
> > --
> > John Shahan
> I am not sure this will help but...
> Leave the formatting alone and just use the expression builder
> In database column (lets call is percentField), number is like this...
> 123.456789 then in expression builder '=Fields!percentField.Value +
> "%" ' - field should look like 123.456789% on the report.
> ..123456789 then in expression builder '=(Fields!percentField.Value
> *100) + "%" ' - field should look like 123.456789% on the report.
> I hope that is what you were talking about and I hope that helps you.
> Thanks and have a great day,
> Kerrie
>|||On Feb 1, 4:49 am, jp <j...@.discussions.microsoft.com> wrote:
> Using SQLRS 2005
> No matter how I format the percentage (using FormatPercent or "P" format
> option, my text box in a table control rounds the percentage to a whole
> percentage with zeroes in the decimal columns.
> I don't want it to round off at all.
> Any pointers?
> --
> John Shahan
You can specify the number of decimal places you would like to see in
the percentage, using the
FormatPercent(number, DecimalPlaces) function. However, this will show
zeros if the percent is a whole number. If you want sometimes to show
decimal places, but to show no trailing zeros, then you probably need
to construct the number manually (division, then multiply by 100) and
add the % sign on the end as a string.
Rowen|||On Jan 31, 6:33 pm, "Rowen" <rowen...@.gmail.com> wrote:
> On Feb 1, 4:49 am, jp <j...@.discussions.microsoft.com> wrote:
> > Using SQLRS 2005
> > No matter how I format the percentage (using FormatPercent or "P" format
> > option, my text box in a table control rounds the percentage to a whole
> > percentage with zeroes in the decimal columns.
> > I don't want it to round off at all.
> > Any pointers?
> > --
> > John Shahan
> You can specify the number of decimal places you would like to see in
> the percentage, using the
> FormatPercent(number, DecimalPlaces) function. However, this will show
> zeros if the percent is a whole number. If you want sometimes to show
> decimal places, but to show no trailing zeros, then you probably need
> to construct the number manually (division, then multiply by 100) and
> add the % sign on the end as a string.
> Rowen
I would definitly try Rowan's suggestions, but what do you have the
format as on the table for that field? Something is set and it needs
to be turned off. I would leave it on 'General' or 'g' on the format
property.
Kerrie
Percentage of total
This is a multi-part message in MIME format.
--=_NextPart_000_0181_01C87662.85ABCAC0
Content-Type: text/plain;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable
I want to create such a report:
Dep. Sales %T1 %T2
Division A
=3D=3D=3D=3D=3D=3D=3D
Department1 10 10% 2%
Department2 40 40% 8%
Department3 50 50% 10%
---
Total A 100 100% 20%
Division B
=3D=3D=3D=3D=3D=3D=3D
Department4 100 25% 20% Department5 300 75% 60%
---
Total A 400 100% 80%
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Total 500 100%
What is the right way to calculate the Percentage for each Department?
Should I calculate it in the SQL or could I use the abilities of SSRS?
--=_NextPart_000_0181_01C87662.85ABCAC0
Content-Type: text/html;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I want to create such a report:
Dep. = Sales %T1 %T2
Division A
=3D=3D=3D=3D=3D=3D=3D
Department1 = 10 10% 2%
Department2 = 40 40% 8%
Department3 = 50 50% 10%
---
Total A 100 &nb= sp; 100% 20%
Division B
=3D=3D=3D=3D=3D=3D=3D
Department4 100 25% 20%
Department5 300 75% 60%
---
Total A 400 &nb= sp; 100% 80%
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D
Total = 500 100%
What is the right way to calculate the = Percentage for each Department?
Should I calculate it in the SQL or = could I use the abilities of SSRS?
--=_NextPart_000_0181_01C87662.85ABCAC0--On Feb 23, 1:24 pm, "Geri Reshef" <gershon_res...@.recanati-
alum.tau.ac.il> wrote:
> I want to create such a report:
> Dep. Sales %T1 %T2
> Division A
> =======> Department1 10 10% 2%
> Department2 40 40% 8%
> Department3 50 50% 10%
> ---
> Total A 100 100% 20%
> Division B
> =======> Department4 100 25% 20%
> Department5 300 75% 60%
> ---
> Total A 400 100% 80%
> ========================> Total 500 100%
> What is the right way to calculate the Percentage for each Department?
> Should I calculate it in the SQL or could I use the abilities of SSRS?
You can do it either way. In SSRS, you could use an expression similar
to this to get the percentages per department.
=(Fields!Sales.Value/Sum(Fields!Sales.Value)) * 100
And then in the format section of the table column properties for the
T1 column, set the format to: #.00%
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant'
--=_NextPart_000_0181_01C87662.85ABCAC0
Content-Type: text/plain;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable
I want to create such a report:
Dep. Sales %T1 %T2
Division A
=3D=3D=3D=3D=3D=3D=3D
Department1 10 10% 2%
Department2 40 40% 8%
Department3 50 50% 10%
---
Total A 100 100% 20%
Division B
=3D=3D=3D=3D=3D=3D=3D
Department4 100 25% 20% Department5 300 75% 60%
---
Total A 400 100% 80%
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Total 500 100%
What is the right way to calculate the Percentage for each Department?
Should I calculate it in the SQL or could I use the abilities of SSRS?
--=_NextPart_000_0181_01C87662.85ABCAC0
Content-Type: text/html;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I want to create such a report:
Dep. = Sales %T1 %T2
Division A
=3D=3D=3D=3D=3D=3D=3D
Department1 = 10 10% 2%
Department2 = 40 40% 8%
Department3 = 50 50% 10%
---
Total A 100 &nb= sp; 100% 20%
Division B
=3D=3D=3D=3D=3D=3D=3D
Department4 100 25% 20%
Department5 300 75% 60%
---
Total A 400 &nb= sp; 100% 80%
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D
Total = 500 100%
What is the right way to calculate the = Percentage for each Department?
Should I calculate it in the SQL or = could I use the abilities of SSRS?
--=_NextPart_000_0181_01C87662.85ABCAC0--On Feb 23, 1:24 pm, "Geri Reshef" <gershon_res...@.recanati-
alum.tau.ac.il> wrote:
> I want to create such a report:
> Dep. Sales %T1 %T2
> Division A
> =======> Department1 10 10% 2%
> Department2 40 40% 8%
> Department3 50 50% 10%
> ---
> Total A 100 100% 20%
> Division B
> =======> Department4 100 25% 20%
> Department5 300 75% 60%
> ---
> Total A 400 100% 80%
> ========================> Total 500 100%
> What is the right way to calculate the Percentage for each Department?
> Should I calculate it in the SQL or could I use the abilities of SSRS?
You can do it either way. In SSRS, you could use an expression similar
to this to get the percentages per department.
=(Fields!Sales.Value/Sum(Fields!Sales.Value)) * 100
And then in the format section of the table column properties for the
T1 column, set the format to: #.00%
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant'
Subscribe to:
Posts (Atom)