Find SQL solutions with free eBooks. Search the ebooks NOW.

XML and SQL: Developing Web Applications
http://www.ebook5.com/readingeBook5...ageno
=2
SQL Performance Tuning
http://www.ebook5.com/ebook5details...=1&subcatid=136
Microsoft SQL Server 2000: A Guide to Enhancements and New Features
http://www.ebook5.com/readingeBook5...ageno
=5
and much more!Are these true? Does anybody know?
--
I like solving problems, and making friends. If this post helpful to you,
please click Yes.
"MCAD Poster" wrote:

> XML and SQL: Developing Web Applications
> http://www.ebook5.com/readingeBook5...age
no=2
> SQL Performance Tuning
> http://www.ebook5.com/ebook5details...age
no=5
> and much more!
>

find out lock start time

I think it would be great to investigate into system performance and dead
lock if we can find out the start time for the current locks. Is there a way
to do that? thanks!
I tried the following 2 methods:
1) EXEC sp_lock
2) In the enterprice manager | management | current activities |
locks/object
Neither view gives me what I'm looking for.
thanks again!
Maybe these will help:
http://msdn.microsoft.com/library/de...tabse_5xrn.asp
Troubleshooting Deadlocks
http://www.support.microsoft.com/?id=224453 Blocking Problems
http://www.support.microsoft.com/?id=271509 How to monitor SQL 2000
Blocking
Andrew J. Kelly SQL MVP
"Zeng" <zeng@.nononospam.com> wrote in message
news:%23ATn9732GHA.2096@.TK2MSFTNGP05.phx.gbl...
> I think it would be great to investigate into system performance and dead
> lock if we can find out the start time for the current locks. Is there a
> way to do that? thanks!
> I tried the following 2 methods:
> 1) EXEC sp_lock
> 2) In the enterprice manager | management | current activities |
> locks/object
> Neither view gives me what I'm looking for.
> thanks again!
>

find out lock start time

I think it would be great to investigate into system performance and dead
lock if we can find out the start time for the current locks. Is there a way
to do that? thanks!
I tried the following 2 methods:
1) EXEC sp_lock
2) In the enterprice manager | management | current activities |
locks/object
Neither view gives me what I'm looking for.
thanks again!Maybe these will help:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servdatabse_5xrn.asp
Troubleshooting Deadlocks
http://www.support.microsoft.com/?id=224453 Blocking Problems
http://www.support.microsoft.com/?id=271509 How to monitor SQL 2000
Blocking
Andrew J. Kelly SQL MVP
"Zeng" <zeng@.nononospam.com> wrote in message
news:%23ATn9732GHA.2096@.TK2MSFTNGP05.phx.gbl...
> I think it would be great to investigate into system performance and dead
> lock if we can find out the start time for the current locks. Is there a
> way to do that? thanks!
> I tried the following 2 methods:
> 1) EXEC sp_lock
> 2) In the enterprice manager | management | current activities |
> locks/object
> Neither view gives me what I'm looking for.
> thanks again!
>

find out lock start time

I think it would be great to investigate into system performance and dead
lock if we can find out the start time for the current locks. Is there a way
to do that? thanks!
I tried the following 2 methods:
1) EXEC sp_lock
2) In the enterprice manager | management | current activities |
locks/object
Neither view gives me what I'm looking for.
thanks again!Maybe these will help:
http://msdn.microsoft.com/library/d...
tabse_5xrn.asp
Troubleshooting Deadlocks
http://www.support.microsoft.com/?id=224453 Blocking Problems
http://www.support.microsoft.com/?id=271509 How to monitor SQL 2000
Blocking
Andrew J. Kelly SQL MVP
"Zeng" <zeng@.nononospam.com> wrote in message
news:%23ATn9732GHA.2096@.TK2MSFTNGP05.phx.gbl...
> I think it would be great to investigate into system performance and dead
> lock if we can find out the start time for the current locks. Is there a
> way to do that? thanks!
> I tried the following 2 methods:
> 1) EXEC sp_lock
> 2) In the enterprice manager | management | current activities |
> locks/object
> Neither view gives me what I'm looking for.
> thanks again!
>

find out how often is a table get updated/inserted

How can I find out how often is a table get updated/inserted?
I'm planning to use sql profiler or maybe performance monitor, but I'm not
sure how to do that. I don't know what criteria should be set to catch them.
I know I can do a trigger and log to a log table. but I wondered if there
is alternative way, use either sql profiler or performance monitor.
You can use profiler, capture the data to a file or table...
The event should be SQL Statement Ending. Then capture whatever counters
you wish...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kenny" <pearl_77@.hotmail.com> wrote in message
news:%23KZroFBcEHA.2812@.TK2MSFTNGP11.phx.gbl...
> How can I find out how often is a table get updated/inserted?
> I'm planning to use sql profiler or maybe performance monitor, but I'm not
> sure how to do that. I don't know what criteria should be set to catch
them.
> I know I can do a trigger and log to a log table. but I wondered if there
> is alternative way, use either sql profiler or performance monitor.
>

find out how often is a table get updated/inserted

How can I find out how often is a table get updated/inserted?
I'm planning to use sql profiler or maybe performance monitor, but I'm not
sure how to do that. I don't know what criteria should be set to catch them.
I know I can do a trigger and log to a log table. but I wondered if there
is alternative way, use either sql profiler or performance monitor.You can use profiler, capture the data to a file or table...
The event should be SQL Statement Ending. Then capture whatever counters
you wish...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kenny" <pearl_77@.hotmail.com> wrote in message
news:%23KZroFBcEHA.2812@.TK2MSFTNGP11.phx.gbl...
> How can I find out how often is a table get updated/inserted?
> I'm planning to use sql profiler or maybe performance monitor, but I'm not
> sure how to do that. I don't know what criteria should be set to catch
them.
> I know I can do a trigger and log to a log table. but I wondered if there
> is alternative way, use either sql profiler or performance monitor.
>

find out how often is a table get updated/inserted

How can I find out how often is a table get updated/inserted?
I'm planning to use sql profiler or maybe performance monitor, but I'm not
sure how to do that. I don't know what criteria should be set to catch them.
I know I can do a trigger and log to a log table. but I wondered if there
is alternative way, use either sql profiler or performance monitor.You can use profiler, capture the data to a file or table...
The event should be SQL Statement Ending. Then capture whatever counters
you wish...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kenny" <pearl_77@.hotmail.com> wrote in message
news:%23KZroFBcEHA.2812@.TK2MSFTNGP11.phx.gbl...
> How can I find out how often is a table get updated/inserted?
> I'm planning to use sql profiler or maybe performance monitor, but I'm not
> sure how to do that. I don't know what criteria should be set to catch
them.
> I know I can do a trigger and log to a log table. but I wondered if there
> is alternative way, use either sql profiler or performance monitor.
>

Filtering Records Out in DSV. Performance Benefit?

In short, will it be advantageous for me to filter out records that are not associated with any facts within the DSV?

For example, there are records in our Products dimension that have no facts associated with them and I'm thinking of doing the following for the Products table in the cube's DSV:

select *
from products (nolock)
where product_key not in (
select distinct product_key from [sales fact] (nolock)
) or product_key not in (
select distinct product_key from [forecast fact] (nolock)
)

Doing this would filter out around 15,000 rows.This isn't a performance question - this is a functionality question. Do you want your dimensions to have members, which (currently) don't have any data associated with them ? If yes - then you need to do this filtering in DSV. If no - then not. As far as performance goes, I imagine that by doing this filtering you will make performance worse, since during processing of dimension it will have to do join with two fact tables.|||

Mosha Pasumansky wrote:

This isn't a performance question - this is a functionality question. Do you want your dimensions to have members, which (currently) don't have any data associated with them ? If yes - then you need to do this filtering in DSV. If no - then not. As far as performance goes, I imagine that by doing this filtering you will make performance worse, since during processing of dimension it will have to do join with two fact tables.

I'm not too concerned with the performance hit during the processing of the cube since we do it night.

So there's really no performance benefit to filtering out the "unnecessary" data?|||Again, if it is OK for you to have less dimension members in the dimension - you may see some performance benefits during qurying. Whether or not you will see this benefit depends greatly on the queries you are sending, on the calculations inside cube etc.|||

Hi,

I did this for AS2000 and do this for AS2005. It help me. I have only about 2 Millions dimension members instead of 5. I make a sence.

But take a look at you query

select *
from products (nolock)
where product_key not in (
select distinct product_key from [sales fact] (nolock)
) or product_key not in (
select distinct product_key from [forecast fact] (nolock)
)

You should rewrite it without "distinct" but should have an index on the product_key field.