Showing posts with label total. Show all posts
Showing posts with label total. Show all posts

Monday, March 26, 2012

How much memory can SQL Server 2000 std. address

How much memory can SQL Server 2000 std. address?
SQL Server 2000 std. is running on Windows 2003 server std edition.
Total memory was 1.5 GB but extra memory was added later.
How can I check how much memory is the SQL server configured to
address? Is there a dbcc command.
Any help will be appreciated.
2 GB.
You can check the "max server memory (mb)" setting using sp_configure ...
But remember that just because it is configured to use 2 GB doesn't
necessarily mean that it will do so -- it might not need that much.
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"sql" <sql@.discussions.microsoft.com> wrote in message
news:37D5B093-4776-4693-93BD-E17FA54B50F4@.microsoft.com...
> How much memory can SQL Server 2000 std. address?
> SQL Server 2000 std. is running on Windows 2003 server std edition.
> Total memory was 1.5 GB but extra memory was added later.
>
> How can I check how much memory is the SQL server configured to
> address? Is there a dbcc command.
>
> Any help will be appreciated.
>
|||Hello,
SQL Server standard can support at a maxuimum of 2 GB RAM. If the memory is
configured to access dynamically then based on the
requuirement SQL Server will use the memory. Use task manager to see how
much memory SQLServr.EXE is using...
Thanks
Hari
"sql" <sql@.discussions.microsoft.com> wrote in message
news:37D5B093-4776-4693-93BD-E17FA54B50F4@.microsoft.com...
> How much memory can SQL Server 2000 std. address?
> SQL Server 2000 std. is running on Windows 2003 server std edition.
> Total memory was 1.5 GB but extra memory was added later.
>
> How can I check how much memory is the SQL server configured to
> address? Is there a dbcc command.
>
> Any help will be appreciated.
>
|||On Jun 20, 5:00 am, sql <s...@.discussions.microsoft.com> wrote:
> How much memory can SQL Server 2000 std. address?
> SQL Server 2000 std. is running on Windows 2003 server std edition.
> Total memory was 1.5 GB but extra memory was added later.
> How can I check how much memory is the SQL server configured to
> address? Is there a dbcc command.
> Any help will be appreciated.
SELECT * FROM sysperfinfo WHERE counter_name ='Total Server Memory
(KB)'

How much memory can SQL Server 2000 std. address

How much memory can SQL Server 2000 std. address?
SQL Server 2000 std. is running on Windows 2003 server std edition.
Total memory was 1.5 GB but extra memory was added later.
How can I check how much memory is the SQL server configured to
address? Is there a dbcc command.
Any help will be appreciated.2 GB.
You can check the "max server memory (mb)" setting using sp_configure ...
But remember that just because it is configured to use 2 GB doesn't
necessarily mean that it will do so -- it might not need that much.
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"sql" <sql@.discussions.microsoft.com> wrote in message
news:37D5B093-4776-4693-93BD-E17FA54B50F4@.microsoft.com...
> How much memory can SQL Server 2000 std. address?
> SQL Server 2000 std. is running on Windows 2003 server std edition.
> Total memory was 1.5 GB but extra memory was added later.
>
> How can I check how much memory is the SQL server configured to
> address? Is there a dbcc command.
>
> Any help will be appreciated.
>|||Hello,
SQL Server standard can support at a maxuimum of 2 GB RAM. If the memory is
configured to access dynamically then based on the
requuirement SQL Server will use the memory. Use task manager to see how
much memory SQLServr.EXE is using...
Thanks
Hari
"sql" <sql@.discussions.microsoft.com> wrote in message
news:37D5B093-4776-4693-93BD-E17FA54B50F4@.microsoft.com...
> How much memory can SQL Server 2000 std. address?
> SQL Server 2000 std. is running on Windows 2003 server std edition.
> Total memory was 1.5 GB but extra memory was added later.
>
> How can I check how much memory is the SQL server configured to
> address? Is there a dbcc command.
>
> Any help will be appreciated.
>|||On Jun 20, 5:00 am, sql <s...@.discussions.microsoft.com> wrote:
> How much memory can SQL Server 2000 std. address?
> SQL Server 2000 std. is running on Windows 2003 server std edition.
> Total memory was 1.5 GB but extra memory was added later.
> How can I check how much memory is the SQL server configured to
> address? Is there a dbcc command.
> Any help will be appreciated.
SELECT * FROM sysperfinfo WHERE counter_name ='Total Server Memory
(KB)'

How much memory can SQL Server 2000 std. address

How much memory can SQL Server 2000 std. address?
SQL Server 2000 std. is running on Windows 2003 server std edition.
Total memory was 1.5 GB but extra memory was added later.
How can I check how much memory is the SQL server configured to
address? Is there a dbcc command.
Any help will be appreciated.2 GB.
You can check the "max server memory (mb)" setting using sp_configure ...
But remember that just because it is configured to use 2 GB doesn't
necessarily mean that it will do so -- it might not need that much.
--
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"sql" <sql@.discussions.microsoft.com> wrote in message
news:37D5B093-4776-4693-93BD-E17FA54B50F4@.microsoft.com...
> How much memory can SQL Server 2000 std. address?
> SQL Server 2000 std. is running on Windows 2003 server std edition.
> Total memory was 1.5 GB but extra memory was added later.
>
> How can I check how much memory is the SQL server configured to
> address? Is there a dbcc command.
>
> Any help will be appreciated.
>|||Hello,
SQL Server standard can support at a maxuimum of 2 GB RAM. If the memory is
configured to access dynamically then based on the
requuirement SQL Server will use the memory. Use task manager to see how
much memory SQLServr.EXE is using...
Thanks
Hari
"sql" <sql@.discussions.microsoft.com> wrote in message
news:37D5B093-4776-4693-93BD-E17FA54B50F4@.microsoft.com...
> How much memory can SQL Server 2000 std. address?
> SQL Server 2000 std. is running on Windows 2003 server std edition.
> Total memory was 1.5 GB but extra memory was added later.
>
> How can I check how much memory is the SQL server configured to
> address? Is there a dbcc command.
>
> Any help will be appreciated.
>|||On Jun 20, 5:00 am, sql <s...@.discussions.microsoft.com> wrote:
> How much memory can SQL Server 2000 std. address?
> SQL Server 2000 std. is running on Windows 2003 server std edition.
> Total memory was 1.5 GB but extra memory was added later.
> How can I check how much memory is the SQL server configured to
> address? Is there a dbcc command.
> Any help will be appreciated.
SELECT * FROM sysperfinfo WHERE counter_name ='Total Server Memory
(KB)'

Sunday, February 19, 2012

How I can calculate the % in the matix's details base on the matix's subtotal?

This is my problem:

Region1 Region2 Total
duration % duration % duration %

call1 10 10 90 90 100 100
call2 10 10 90 90 100 100

How I can calculate the %, I need to know the total duration!
Nobody can help me?

abc_abc

Do the following

Divide each column in the matrix by the row total and multiply by hundred. Dividing by the row total is a matter of scope. If you go to the edit group properties in you row group, you can see the name of your row scope. So simply divide the current row,col value by Sum(fieldname,rowscope). Remeber to change all your results to a string and concatentate them. i.e. row val.ToString() + " " + computed percentage.ToString().

I am assuming, that u have a single matrix.

Umer

|||Yes I have a single matrix, but it doesn't work... I m sure I'm in wrong in something.
The group Total is the same of Region1 and Region2, I used the Subtotal by right-click

I have written this expression in the matrix's detalil
=(Sum(Fields!Duration)/sum(Fields!Duration.Value,"matrix_Region"))*100

but something is wrong.
but I don't understand what!|||Now it works, thanks...
In the group'scope I used the "latest" row-groups before datails.
abc_abc