Determine performance issue

I read from a book and part of the comment, it mention this:
========================
After further analysis, we determined that more than
80 percent of the total resources being consumed-processor, memory,
and
input/output (I/O)-was involved in this conversion process.
========================
The conversion process in the comment is the conversion of datetime
format to another format.
QUESTION:
1. How can we determine the percentage of time was involve in
conversion process?
2. How can we check for it? Using profiler?
I'm interested to the method of checking performance problem, but have
no idea where to start with and what to check.
Any guideline?
Thanks.
wodoy.peter
One reliable method is to conduct controled tests to compare the performance
between using the conversion and not using the conversion. This may not be
possible in some scenario, and may be too expensive in some other scenarios.
Without such a comparison, I'm not sure how one can determine with certainty
that X% of resources is being consumed by a conversion step by looking at
perfmon counters or SQL Trace results.
Linchi
"wodoy.peter" wrote:

> I read from a book and part of the comment, it mention this:
> ========================
> After further analysis, we determined that more than
> 80 percent of the total resources being consumed-processor, memory,
> and
> input/output (I/O)-was involved in this conversion process.
> ========================
> The conversion process in the comment is the conversion of datetime
> format to another format.
> QUESTION:
> 1. How can we determine the percentage of time was involve in
> conversion process?
> 2. How can we check for it? Using profiler?
> I'm interested to the method of checking performance problem, but have
> no idea where to start with and what to check.
> Any guideline?
> Thanks.
>
> wodoy.peter
>
|||On Fri, 2 Feb 2007 14:12:01 -0800, Linchi Shea
<LinchiShea@.discussions.microsoft.com> wrote:

>One reliable method is to conduct controled tests to compare the performance
>between using the conversion and not using the conversion. This may not be
>possible in some scenario, and may be too expensive in some other scenarios.
Excellent point, just comment out the line and use the wall clock!
When possible ...

>Without such a comparison, I'm not sure how one can determine with certainty
>that X% of resources is being consumed by a conversion step by looking at
>perfmon counters or SQL Trace results.
Profiler can give you some pretty fine-grained results, if you turn
everything on. It also impacts performance, especially at those
levels.
J.

Determine performance issue

I read from a book and part of the comment, it mention this:
======================== After further analysis, we determined that more than
80 percent of the total resources being consumed-processor, memory,
and
input/output (I/O)-was involved in this conversion process.
========================
The conversion process in the comment is the conversion of datetime
format to another format.
QUESTION:
1. How can we determine the percentage of time was involve in
conversion process?
2. How can we check for it? Using profiler?
I'm interested to the method of checking performance problem, but have
no idea where to start with and what to check.
Any guideline?
Thanks.
wodoy.peterOne reliable method is to conduct controled tests to compare the performance
between using the conversion and not using the conversion. This may not be
possible in some scenario, and may be too expensive in some other scenarios.
Without such a comparison, I'm not sure how one can determine with certainty
that X% of resources is being consumed by a conversion step by looking at
perfmon counters or SQL Trace results.
Linchi
"wodoy.peter" wrote:
> I read from a book and part of the comment, it mention this:
> ========================> After further analysis, we determined that more than
> 80 percent of the total resources being consumed-processor, memory,
> and
> input/output (I/O)-was involved in this conversion process.
> ========================> The conversion process in the comment is the conversion of datetime
> format to another format.
> QUESTION:
> 1. How can we determine the percentage of time was involve in
> conversion process?
> 2. How can we check for it? Using profiler?
> I'm interested to the method of checking performance problem, but have
> no idea where to start with and what to check.
> Any guideline?
> Thanks.
>
> wodoy.peter
>|||On Fri, 2 Feb 2007 14:12:01 -0800, Linchi Shea
<LinchiShea@.discussions.microsoft.com> wrote:
>One reliable method is to conduct controled tests to compare the performance
>between using the conversion and not using the conversion. This may not be
>possible in some scenario, and may be too expensive in some other scenarios.
Excellent point, just comment out the line and use the wall clock!
When possible ...
>Without such a comparison, I'm not sure how one can determine with certainty
>that X% of resources is being consumed by a conversion step by looking at
>perfmon counters or SQL Trace results.
Profiler can give you some pretty fine-grained results, if you turn
everything on. It also impacts performance, especially at those
levels.
J.

Determine performance issue

I read from a book and part of the comment, it mention this:
========================
After further analysis, we determined that more than
80 percent of the total resources being consumed-processor, memory,
and
input/output (I/O)-was involved in this conversion process.
========================
The conversion process in the comment is the conversion of datetime
format to another format.
QUESTION:
1. How can we determine the percentage of time was involve in
conversion process?
2. How can we check for it? Using profiler?
I'm interested to the method of checking performance problem, but have
no idea where to start with and what to check.
Any guideline?
Thanks.
wodoy.peterOne reliable method is to conduct controled tests to compare the performance
between using the conversion and not using the conversion. This may not be
possible in some scenario, and may be too expensive in some other scenarios.
Without such a comparison, I'm not sure how one can determine with certainty
that X% of resources is being consumed by a conversion step by looking at
perfmon counters or SQL Trace results.
Linchi
"wodoy.peter" wrote:

> I read from a book and part of the comment, it mention this:
> ========================
> After further analysis, we determined that more than
> 80 percent of the total resources being consumed-processor, memory,
> and
> input/output (I/O)-was involved in this conversion process.
> ========================
> The conversion process in the comment is the conversion of datetime
> format to another format.
> QUESTION:
> 1. How can we determine the percentage of time was involve in
> conversion process?
> 2. How can we check for it? Using profiler?
> I'm interested to the method of checking performance problem, but have
> no idea where to start with and what to check.
> Any guideline?
> Thanks.
>
> wodoy.peter
>|||On Fri, 2 Feb 2007 14:12:01 -0800, Linchi Shea
<LinchiShea@.discussions.microsoft.com> wrote:

>One reliable method is to conduct controled tests to compare the performanc
e
>between using the conversion and not using the conversion. This may not be
>possible in some scenario, and may be too expensive in some other scenarios.[/vbcol
]
Excellent point, just comment out the line and use the wall clock!
When possible ...
[vbcol=seagreen]
>Without such a comparison, I'm not sure how one can determine with certaint
y
>that X% of resources is being consumed by a conversion step by looking at
>perfmon counters or SQL Trace results.
Profiler can give you some pretty fine-grained results, if you turn
everything on. It also impacts performance, especially at those
levels.
J.

Designing application using access 2000

I desperately need help. I am new to database design and I am using John viescas book Building microsoft access applications. Idon't know where or how to implement the codes in order to create an application.

The book does not give practical examples as to how to actually design the individual function of the database. Any ideas will be greatly welcomed as I am getting quite frustrated just reading meaningless text.

Hi,

this is no Acess group the "SQL Server Data Access" title mean Data Access to SQL Server. I think you are better occupied posting in a Access group like the one which can be found on the public Microsoft newsservers.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||if you want to do database design with sql server. BOL or books online which ships with the product is a good place to start.

Designing "XML Proof" databases?

Hello All,
I'm fairly new to the XML game. I am designing a database that will contain
online books. Each book will be broken into parts, each part into chapters,
each chapter into sections, each section into... you get the idea. I think
this is the perfect opportunity for the XML data type in Yukon. However, I
did to put this database together in the next few weeks.
My question is whether there are any best practices for designing
traditional heirarchical databases today that will smoothly transition into
an XML future. (Books, articles, suggestions here, etc.?)
I need to have each text snippet as it's own record in one table (snippetID,
title, body, etc.) I was thinking that I would create a second table for the
heirarchy itself where I would maintain the relationships tied back to the
specific snippetID's. My plan was to use SQLXML to represent the data as XML
(which I think could drive a cool DHTML menu). But, I wonder if this is the
right approach given that yukon is around the corner (yet that I need this
before Yukon's release date?)
Thanks so much,
Brian
What do you do with the data once it is stored in the database?
Do you store and retrieve the document as a whole? In that case, I would
keep the document as an NTEXT or TEXT field depending on the encoding of the
XML and propagate some lookup info into other columns. This will be easily
converted into the XML datatype.
If you are planning on doing extensive reshaping and or selecting only
parts, you may want to partition the XML into separate components and then
do the same as above...
Best regards
Michael
"Brian Madden" <brian@.brianmadden.com> wrote in message
news:uF2NsxF3EHA.1396@.tk2msftngp13.phx.gbl...
> Hello All,
> I'm fairly new to the XML game. I am designing a database that will
> contain online books. Each book will be broken into parts, each part into
> chapters, each chapter into sections, each section into... you get the
> idea. I think this is the perfect opportunity for the XML data type in
> Yukon. However, I did to put this database together in the next few weeks.
> My question is whether there are any best practices for designing
> traditional heirarchical databases today that will smoothly transition
> into an XML future. (Books, articles, suggestions here, etc.?)
> I need to have each text snippet as it's own record in one table
> (snippetID, title, body, etc.) I was thinking that I would create a second
> table for the heirarchy itself where I would maintain the relationships
> tied back to the specific snippetID's. My plan was to use SQLXML to
> represent the data as XML (which I think could drive a cool DHTML menu).
> But, I wonder if this is the right approach given that yukon is around the
> corner (yet that I need this before Yukon's release date?)
> Thanks so much,
> Brian
>