Mem to Leave...

Are there any tools or documentation available anywhere that describes how
one can monitor the usage/fragmentation of the mem to leave area used by SQL
Server? (SQL2K on W2K3 2 Node Cluster)One tool is VMStat. You can download it with the psslabs2004
download. You can download it from:
http://www.microsoft.com/downloads/details.aspx?FamilyID=aec18337-887f-4ec6-a858-81f84de8082f&DisplayLang=en
-Sue
On Mon, 23 Jan 2006 12:25:02 -0800, "Cyberstorme"
<Cyberstorme@.discussions.microsoft.com> wrote:
>Are there any tools or documentation available anywhere that describes how
>one can monitor the usage/fragmentation of the mem to leave area used by SQL
>Server? (SQL2K on W2K3 2 Node Cluster)sql

Mem to Leave...

Are there any tools or documentation available anywhere that describes how
one can monitor the usage/fragmentation of the mem to leave area used by SQL
Server? (SQL2K on W2K3 2 Node Cluster)
One tool is VMStat. You can download it with the psslabs2004
download. You can download it from:
http://www.microsoft.com/downloads/d...DisplayLang=en
-Sue
On Mon, 23 Jan 2006 12:25:02 -0800, "Cyberstorme"
<Cyberstorme@.discussions.microsoft.com> wrote:

>Are there any tools or documentation available anywhere that describes how
>one can monitor the usage/fragmentation of the mem to leave area used by SQL
>Server? (SQL2K on W2K3 2 Node Cluster)

Mem to Leave...

Are there any tools or documentation available anywhere that describes how
one can monitor the usage/fragmentation of the mem to leave area used by SQL
Server? (SQL2K on W2K3 2 Node Cluster)One tool is VMStat. You can download it with the psslabs2004
download. You can download it from:
1f84de8082f&DisplayLang=en" target="_blank">http://www.microsoft.com/downloads/...&DisplayLang=en
-Sue
On Mon, 23 Jan 2006 12:25:02 -0800, "Cyberstorme"
<Cyberstorme@.discussions.microsoft.com> wrote:

>Are there any tools or documentation available anywhere that describes how
>one can monitor the usage/fragmentation of the mem to leave area used by SQ
L
>Server? (SQL2K on W2K3 2 Node Cluster)

Meaning of datacode in sysdtslog90?

The documentation says:

"An integer value that identifies the event associated with the log entry. The value 0 indicates the event provided no identifier."

When I look at the sysdtslog90 table and I filter for 'PackageEnd' events, I see a value of 0, 1 or 3 in the datacode column. Is there any information I can glean from these values, e.g. package success or failure?

Did you ever get an answer to this question? I'm interested.

Thanks!

Meaning of datacode in sysdtslog90?

The documentation says:

"An integer value that identifies the event associated with the log entry. The value 0 indicates the event provided no identifier."

When I look at the sysdtslog90 table and I filter for 'PackageEnd' events, I see a value of 0, 1 or 3 in the datacode column. Is there any information I can glean from these values, e.g. package success or failure?

Did you ever get an answer to this question? I'm interested.

Thanks!

MDX Sumproduct and excel functions

Hi
Has anyone used SUMPRODUCT in a calculated member in analysis services?
Apparantly, according to MS documentation, its possible, but I can see
nothing in the books online - or on the web.
I am using the syntax below, which I would have thought would have worked.
SUMPRODUCT({[Accounts].&[123],[Accounts].&[456]},{
[Accounts].&[111],[Accounts].&[321]})
So does anyone know how to use SUMPRODUCT with AS?
Thank you for your help
JeremySince the arguments to SumProduct() are arrays, use the MDX SetToArray()
function to generate them. The second argument to SetToArray() is the
numerical value to use:
[vbcol=seagreen]
SUMPRODUCT(
SetToArray({[Accounts].&[123],[Accounts].&[456]},
[Measures].[Sales]),
SetToArray({[Accounts].&[111],[Accounts].&[321]},
[Measures].[Sales]))[vbcol=seagreen]
From SQL Server BOL>>
SetToArray
Converts one or more sets to an array for use in a user-defined
function.
Syntax
SetToArray(Set[, Set...][, Numeric Expression])
Remarks
This function converts one or more sets to an array for use in a
user-defined function. The number of dimensions in the resulting array
is the same as the number of sets specified.
The optional numeric expression can be used to provide the values in the
array cells. If omitted, the default value of the set member is used for
the array cell value.
..[vbcol=seagreen]
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!