Algorithm needed

We are in the process of converting our existing in-house asp web sites to
Sharepoint. Our existing web site has many PDF's, images, etc. These all
reside on the server in a Folder\file. Since Sharepoint now a database
driven architecture, I was wondering if anyone could assist me with some sor
t
of estimate of how much disk space I will need.
I know that Sharepoint stores images, PDFs, etc as BLOBS in the database. I
have no idea of the algorithm or conversion process used.
We will be using SQLServer 2005 database.
Can anyone help me with a formula or algorithm that I can use to estimate
the size of my database when I convert my text files, pdfs, images to
SQLServer 2005 blob files?
Thanks Tomblob is binary storage
the size stored is the same as the source file.
a 1Mb file will consume 1Mb in the database too.
(+ some bytes for the row information, ids etc... this overhead is small)
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:C10E3198-693D-4845-B89C-C00578FD6C47@.microsoft.com...
> We are in the process of converting our existing in-house asp web sites
> to
> Sharepoint. Our existing web site has many PDF's, images, etc. These all
> reside on the server in a Folder\file. Since Sharepoint now a database
> driven architecture, I was wondering if anyone could assist me with some
> sort
> of estimate of how much disk space I will need.
> I know that Sharepoint stores images, PDFs, etc as BLOBS in the database.
> I
> have no idea of the algorithm or conversion process used.
> We will be using SQLServer 2005 database.
> Can anyone help me with a formula or algorithm that I can use to estimate
> the size of my database when I convert my text files, pdfs, images to
> SQLServer 2005 blob files?
> Thanks Tom|||Jéjé.
Are you saying the size is the same whether its a File, PDF, or image?
ThanksJéjé
"Jéjé" wrote:

> blob is binary storage
> the size stored is the same as the source file.
> a 1Mb file will consume 1Mb in the database too.
> (+ some bytes for the row information, ids etc... this overhead is small)
>
> "Tom" <Tom@.discussions.microsoft.com> wrote in message
> news:C10E3198-693D-4845-B89C-C00578FD6C47@.microsoft.com...
>
>|||Jj means the size of an image value in the database will be the same size
as the source, plus some overhead. SQL Server doesn't know or care about
the content of data stored in image/varbinary/binary columns.
I don't know much about Sharepoint but I understand the product optionally
has full-text search capability, which can contribute to storage
requirements.
Hope this helps.
Dan Guzman
SQL Server MVP
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:6CEFCA87-3EA6-4505-BD2B-B4DE26FD75D0@.microsoft.com...[vbcol=seagreen]
> Jj.
> Are you saying the size is the same whether its a File, PDF, or image?
> ThanksJj
>
> "Jj" wrote:
>|||you are right, if you index the content, then there is the indexation
overhead too.
but its the same way if you index the document from the disk or from the
database, the result is the same and the overhead is near the same too.
Maybe sharepoint store more metadata information, but again, the size of
this metadata is small.
and Yes, SQL Server store the content as is, its a byte storage, there is no
compression, no format changes.
so the size of the source file doesn't change.
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:OpSh1kxxGHA.3440@.TK2MSFTNGP06.phx.gbl...
> Jj means the size of an image value in the database will be the same
> size as the source, plus some overhead. SQL Server doesn't know or care
> about the content of data stored in image/varbinary/binary columns.
> I don't know much about Sharepoint but I understand the product optionally
> has full-text search capability, which can contribute to storage
> requirements.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Tom" <Tom@.discussions.microsoft.com> wrote in message
> news:6CEFCA87-3EA6-4505-BD2B-B4DE26FD75D0@.microsoft.com...
>

Algorithm needed

We are in the process of converting our existing in-house asp web sites to
Sharepoint. Our existing web site has many PDF's, images, etc. These all
reside on the server in a Folder\file. Since Sharepoint now a database
driven architecture, I was wondering if anyone could assist me with some sort
of estimate of how much disk space I will need.
I know that Sharepoint stores images, PDFs, etc as BLOBS in the database. I
have no idea of the algorithm or conversion process used.
We will be using SQLServer 2005 database.
Can anyone help me with a formula or algorithm that I can use to estimate
the size of my database when I convert my text files, pdfs, images to
SQLServer 2005 blob files?
Thanks Tomblob is binary storage
the size stored is the same as the source file.
a 1Mb file will consume 1Mb in the database too.
(+ some bytes for the row information, ids etc... this overhead is small)
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:C10E3198-693D-4845-B89C-C00578FD6C47@.microsoft.com...
> We are in the process of converting our existing in-house asp web sites
> to
> Sharepoint. Our existing web site has many PDF's, images, etc. These all
> reside on the server in a Folder\file. Since Sharepoint now a database
> driven architecture, I was wondering if anyone could assist me with some
> sort
> of estimate of how much disk space I will need.
> I know that Sharepoint stores images, PDFs, etc as BLOBS in the database.
> I
> have no idea of the algorithm or conversion process used.
> We will be using SQLServer 2005 database.
> Can anyone help me with a formula or algorithm that I can use to estimate
> the size of my database when I convert my text files, pdfs, images to
> SQLServer 2005 blob files?
> Thanks Tom|||Jéjé.
Are you saying the size is the same whether its a File, PDF, or image?
ThanksJéjé
"Jéjé" wrote:
> blob is binary storage
> the size stored is the same as the source file.
> a 1Mb file will consume 1Mb in the database too.
> (+ some bytes for the row information, ids etc... this overhead is small)
>
> "Tom" <Tom@.discussions.microsoft.com> wrote in message
> news:C10E3198-693D-4845-B89C-C00578FD6C47@.microsoft.com...
> > We are in the process of converting our existing in-house asp web sites
> > to
> > Sharepoint. Our existing web site has many PDF's, images, etc. These all
> > reside on the server in a Folder\file. Since Sharepoint now a database
> > driven architecture, I was wondering if anyone could assist me with some
> > sort
> > of estimate of how much disk space I will need.
> >
> > I know that Sharepoint stores images, PDFs, etc as BLOBS in the database.
> > I
> > have no idea of the algorithm or conversion process used.
> >
> > We will be using SQLServer 2005 database.
> >
> > Can anyone help me with a formula or algorithm that I can use to estimate
> > the size of my database when I convert my text files, pdfs, images to
> > SQLServer 2005 blob files?
> >
> > Thanks Tom
>
>|||Jéjé means the size of an image value in the database will be the same size
as the source, plus some overhead. SQL Server doesn't know or care about
the content of data stored in image/varbinary/binary columns.
I don't know much about Sharepoint but I understand the product optionally
has full-text search capability, which can contribute to storage
requirements.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:6CEFCA87-3EA6-4505-BD2B-B4DE26FD75D0@.microsoft.com...
> Jéjé.
> Are you saying the size is the same whether its a File, PDF, or image?
> ThanksJéjé
>
> "Jéjé" wrote:
>> blob is binary storage
>> the size stored is the same as the source file.
>> a 1Mb file will consume 1Mb in the database too.
>> (+ some bytes for the row information, ids etc... this overhead is small)
>>
>> "Tom" <Tom@.discussions.microsoft.com> wrote in message
>> news:C10E3198-693D-4845-B89C-C00578FD6C47@.microsoft.com...
>> > We are in the process of converting our existing in-house asp web sites
>> > to
>> > Sharepoint. Our existing web site has many PDF's, images, etc. These
>> > all
>> > reside on the server in a Folder\file. Since Sharepoint now a database
>> > driven architecture, I was wondering if anyone could assist me with
>> > some
>> > sort
>> > of estimate of how much disk space I will need.
>> >
>> > I know that Sharepoint stores images, PDFs, etc as BLOBS in the
>> > database.
>> > I
>> > have no idea of the algorithm or conversion process used.
>> >
>> > We will be using SQLServer 2005 database.
>> >
>> > Can anyone help me with a formula or algorithm that I can use to
>> > estimate
>> > the size of my database when I convert my text files, pdfs, images to
>> > SQLServer 2005 blob files?
>> >
>> > Thanks Tom
>>|||you are right, if you index the content, then there is the indexation
overhead too.
but its the same way if you index the document from the disk or from the
database, the result is the same and the overhead is near the same too.
Maybe sharepoint store more metadata information, but again, the size of
this metadata is small.
and Yes, SQL Server store the content as is, its a byte storage, there is no
compression, no format changes.
so the size of the source file doesn't change.
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:OpSh1kxxGHA.3440@.TK2MSFTNGP06.phx.gbl...
> Jéjé means the size of an image value in the database will be the same
> size as the source, plus some overhead. SQL Server doesn't know or care
> about the content of data stored in image/varbinary/binary columns.
> I don't know much about Sharepoint but I understand the product optionally
> has full-text search capability, which can contribute to storage
> requirements.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Tom" <Tom@.discussions.microsoft.com> wrote in message
> news:6CEFCA87-3EA6-4505-BD2B-B4DE26FD75D0@.microsoft.com...
>> Jéjé.
>> Are you saying the size is the same whether its a File, PDF, or image?
>> ThanksJéjé
>>
>> "Jéjé" wrote:
>> blob is binary storage
>> the size stored is the same as the source file.
>> a 1Mb file will consume 1Mb in the database too.
>> (+ some bytes for the row information, ids etc... this overhead is
>> small)
>>
>> "Tom" <Tom@.discussions.microsoft.com> wrote in message
>> news:C10E3198-693D-4845-B89C-C00578FD6C47@.microsoft.com...
>> > We are in the process of converting our existing in-house asp web
>> > sites
>> > to
>> > Sharepoint. Our existing web site has many PDF's, images, etc. These
>> > all
>> > reside on the server in a Folder\file. Since Sharepoint now a
>> > database
>> > driven architecture, I was wondering if anyone could assist me with
>> > some
>> > sort
>> > of estimate of how much disk space I will need.
>> >
>> > I know that Sharepoint stores images, PDFs, etc as BLOBS in the
>> > database.
>> > I
>> > have no idea of the algorithm or conversion process used.
>> >
>> > We will be using SQLServer 2005 database.
>> >
>> > Can anyone help me with a formula or algorithm that I can use to
>> > estimate
>> > the size of my database when I convert my text files, pdfs, images to
>> > SQLServer 2005 blob files?
>> >
>> > Thanks Tom
>>
>

Alerts, Thresholds

Hi All,

Actually i m new in sql server administration. And i m in the process of building our production box with sql server 2005. ( win 2003 std )

Can anybody plz tell me , what all the "Alerts" and their 'Thresholds' i have to configure on my server, so that those can be emailed (or) paged.

And does anybody know like any link, which gives step by step instruction for configuring Database mail with explanations.

Thanks in advance.

//Najeed

Hi,

that highly depends on what other monitoring software you are using and which areas this already covers. But I would go for disk usage and datafile / logfile growth and size. If you experiencing other problems, you might also want to trace / log other parameters, but this depends upon your requirements. Database mail is explained in detail at the MSDN sites:

http://msdn2.microsoft.com/en-us/library/ms186358(SQL.90).aspx

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Alert for Blocked Process?

I am troubleshooting a database from a 3rd party vendor, and we keep coming up with blocked processes. Is there any way to set up an alert that could notify me when a process is blocked?
"Blocking" as such is not a bad thing. It supports ACID and is necessary
for data integrity. The real problem is when the blocking seems to be going
on for a considerable amount of time. That amount of time is something you
could define. Ideally, any process or client connection accessing SQL
Server is given a 'spid'. The spid information is got from the master
database, Sysprocesses table. That has columns as well for the current
status, waittime and waittype. So perhaps, you could set up an alert if
say, for a particular spid, it's status is sleeping and the waittime is
past a certain time that you define.
Hope that helps!
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Alert for Blocked Process?

I am troubleshooting a database from a 3rd party vendor, and we keep coming
up with blocked processes. Is there any way to set up an alert that could no
tify me when a process is blocked?"Blocking" as such is not a bad thing. It supports ACID and is necessary
for data integrity. The real problem is when the blocking seems to be going
on for a considerable amount of time. That amount of time is something you
could define. Ideally, any process or client connection accessing SQL
Server is given a 'spid'. The spid information is got from the master
database, Sysprocesses table. That has columns as well for the current
status, waittime and waittype. So perhaps, you could set up an alert if
say, for a particular spid, it's status is sleeping and the waittime is
past a certain time that you define.
Hope that helps!
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

AJAX Renderer

I'm in the process of writing a new renderer for Reporting Services to get
around some of the problems it's main HTML renderer has - fixed headers,
screen flash, losing scroll position on refresh, customisable refresh rate
etc.
Although it's been fun trying to do this with almost no documentation at
all, the project is almost at an end. However, there is one last thing I'd
like to implement to make life a little more efficient. That is to only send
the changes to the client once the original page has been rendered.
Something like Gmail does with it's JavaScript arrays.
My request is for ideas on how I can create diffs from within the renderer.
Do I need to cache the entire report object model until the next update
request or is there some easy field in the model to say "it's changed"? Does
anyone have any other ideas about how I might do this? What is the best way
of identifying an individual client from within the renderer (my only
current idea is to generate a guid or similar and embed that in the initial
rendering)?
Regards,
James SnapeHello James,
This seems to be more related to report execution and cache management
other than a rendering extension. Based on my scope, the report server
makes every attempt to render a report from its cached copy when caching
has been configured for an individual report. There are some cases in
which the report may not be rendered from cache:
Report parameter values do not match the report parameter values that were
used when executing the report stored in cache.
If a report cannot be rendered from a cached copy the report is be executed
against the data source(s).
Cache Invalidation can based on a period of time or schedule. Usually it is
not feaisble to only create changes between different snapshots so that you
could update client with this differences because there is no method to
reference previous snapshot inside renderring extension.
I believe this may require a bit more in depth attention and may fall under
the umbrella of Advisory Services. Microsoft now offers short-term and
proactive assistance for specific planning, design, development or
assistance with installing, deploying, and general "how to" advice via
telephone. For more information:
http://support.microsoft.com/default.aspx?scid=fh;en-us;advisoryservice
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--
| From: "James Snape" <jim_snape.at.hotmail.com@.online.nospam>
| Subject: AJAX Renderer
| Date: Thu, 6 Oct 2005 12:11:52 +0100
| Lines: 23
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <u0LpGbmyFHA.1256@.TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: ip-213-92-131-1.aramiska-arc.aramiska.net 213.92.131.1
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:53834
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I'm in the process of writing a new renderer for Reporting Services to
get
| around some of the problems it's main HTML renderer has - fixed headers,
| screen flash, losing scroll position on refresh, customisable refresh
rate
| etc.
|
| Although it's been fun trying to do this with almost no documentation at
| all, the project is almost at an end. However, there is one last thing
I'd
| like to implement to make life a little more efficient. That is to only
send
| the changes to the client once the original page has been rendered.
| Something like Gmail does with it's JavaScript arrays.
|
| My request is for ideas on how I can create diffs from within the
renderer.
| Do I need to cache the entire report object model until the next update
| request or is there some easy field in the model to say "it's changed"?
Does
| anyone have any other ideas about how I might do this? What is the best
way
| of identifying an individual client from within the renderer (my only
| current idea is to generate a guid or similar and embed that in the
initial
| rendering)?
|
| Regards,
| James Snape
|
|
||||Hi Peter,
I think you have mostly answered my question in that any differences would
have to be calculated by me and that will create a lot of memory pressure to
store pervious versions of the object model for a large number of clients.
One follow up I have is about when a datasource query happens.. There is no
point having a refreshing report if it is going to just render the same data
from a cache every 10 seconds or so. Currently I'm forcing a
ClearSession=true to make sure the data changes. Can you confirm that this
with ensure data sources are requeried? Are there any other side affects
that I should be aware of?
Regards,
James Snape
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:ETChb%23vyFHA.780@.TK2MSFTNGXA01.phx.gbl...
> Hello James,
> This seems to be more related to report execution and cache management
> other than a rendering extension. Based on my scope, the report server
> makes every attempt to render a report from its cached copy when caching
> has been configured for an individual report. There are some cases in
> which the report may not be rendered from cache:
> Report parameter values do not match the report parameter values that were
> used when executing the report stored in cache.
> If a report cannot be rendered from a cached copy the report is be
> executed
> against the data source(s).
> Cache Invalidation can based on a period of time or schedule. Usually it
> is
> not feaisble to only create changes between different snapshots so that
> you
> could update client with this differences because there is no method to
> reference previous snapshot inside renderring extension.
> I believe this may require a bit more in depth attention and may fall
> under
> the umbrella of Advisory Services. Microsoft now offers short-term and
> proactive assistance for specific planning, design, development or
> assistance with installing, deploying, and general "how to" advice via
> telephone. For more information:
> http://support.microsoft.com/default.aspx?scid=fh;en-us;advisoryservice
> Thanks & Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> --
> | From: "James Snape" <jim_snape.at.hotmail.com@.online.nospam>
> | Subject: AJAX Renderer
> | Date: Thu, 6 Oct 2005 12:11:52 +0100
> | Lines: 23
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | Message-ID: <u0LpGbmyFHA.1256@.TK2MSFTNGP09.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: ip-213-92-131-1.aramiska-arc.aramiska.net
> 213.92.131.1
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:53834
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I'm in the process of writing a new renderer for Reporting Services to
> get
> | around some of the problems it's main HTML renderer has - fixed headers,
> | screen flash, losing scroll position on refresh, customisable refresh
> rate
> | etc.
> |
> | Although it's been fun trying to do this with almost no documentation at
> | all, the project is almost at an end. However, there is one last thing
> I'd
> | like to implement to make life a little more efficient. That is to only
> send
> | the changes to the client once the original page has been rendered.
> | Something like Gmail does with it's JavaScript arrays.
> |
> | My request is for ideas on how I can create diffs from within the
> renderer.
> | Do I need to cache the entire report object model until the next update
> | request or is there some easy field in the model to say "it's changed"?
> Does
> | anyone have any other ideas about how I might do this? What is the best
> way
> | of identifying an individual client from within the renderer (my only
> | current idea is to generate a guid or similar and embed that in the
> initial
> | rendering)?
> |
> | Regards,
> | James Snape
> |
> |
> |
>|||Hello James,
I think it is dependent how the report is configured to execute. By
default, each time a user navigates to a report and selects it for viewing
the report server communicates with and queries the report?s data
source(s), formats the report and renders the report to the specified
format. If the the data within the data source(s) does not change
frequently or if you may want to manage computing resources that are
associated with the execution of a report, you may optionally cache the
report.
Optionally you may configure an individual report to be cached when the
execution of a report is against a live data source(s). If configured to
be cached, when a report is executed for the first time, a copy of the
report (intermediate format) is stored in the cache. Subsequent requests
to the report are served from the cache.
The cached copy of the report may be invalidated based on one of the
following configurable options.
- Cache invalidation based on a period of time expressed in minutes.
- Cache invalidation based on a specific, recurring date and time (Scoped
or Shared Schedule).
Also, a reports cached copy may be invalidated when one of the following
events occur to a report.
- Report Parameters change
- Report Definition changes
- Data Source Credentials change
- Cache Options change
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "James Snape" <jim_snape.at.hotmail.com@.online.nospam>
| References: <u0LpGbmyFHA.1256@.TK2MSFTNGP09.phx.gbl>
<ETChb#vyFHA.780@.TK2MSFTNGXA01.phx.gbl>
| Subject: Re: AJAX Renderer
| Date: Fri, 7 Oct 2005 09:38:11 +0100
| Lines: 134
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| Message-ID: <eieZ5pxyFHA.2312@.TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: ip-213-92-131-1.aramiska-arc.aramiska.net 213.92.131.1
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:53920
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi Peter,
|
| I think you have mostly answered my question in that any differences
would
| have to be calculated by me and that will create a lot of memory pressure
to
| store pervious versions of the object model for a large number of clients.
|
| One follow up I have is about when a datasource query happens.. There is
no
| point having a refreshing report if it is going to just render the same
data
| from a cache every 10 seconds or so. Currently I'm forcing a
| ClearSession=true to make sure the data changes. Can you confirm that
this
| with ensure data sources are requeried? Are there any other side affects
| that I should be aware of?
|
| Regards,
| James Snape
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:ETChb%23vyFHA.780@.TK2MSFTNGXA01.phx.gbl...
| > Hello James,
| >
| > This seems to be more related to report execution and cache management
| > other than a rendering extension. Based on my scope, the report server
| > makes every attempt to render a report from its cached copy when caching
| > has been configured for an individual report. There are some cases in
| > which the report may not be rendered from cache:
| > Report parameter values do not match the report parameter values that
were
| > used when executing the report stored in cache.
| >
| > If a report cannot be rendered from a cached copy the report is be
| > executed
| > against the data source(s).
| >
| > Cache Invalidation can based on a period of time or schedule. Usually
it
| > is
| > not feaisble to only create changes between different snapshots so that
| > you
| > could update client with this differences because there is no method to
| > reference previous snapshot inside renderring extension.
| >
| > I believe this may require a bit more in depth attention and may fall
| > under
| > the umbrella of Advisory Services. Microsoft now offers short-term and
| > proactive assistance for specific planning, design, development or
| > assistance with installing, deploying, and general "how to" advice via
| > telephone. For more information:
| >
| > http://support.microsoft.com/default.aspx?scid=fh;en-us;advisoryservice
| >
| > Thanks & Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > When responding to posts, please "Reply to Group" via your newsreader so
| > that others may learn and benefit from your issue.
| >
| > =====================================================| >
| > Business-Critical Phone Support (BCPS) provides you with technical phone
| > support at no charge during critical LAN outages or "business down"
| > situations. This benefit is available 24 hours a day, 7 days a week to
all
| > Microsoft technology partners in the United States and Canada.
| >
| > This and other support options are available here:
| >
| > BCPS:
| >
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
| >
| > Others:
https://partner.microsoft.com/US/technicalsupport/supportoverview/
| >
| > If you are outside the United States, please visit our International
| > Support page:
| > http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
| >
| > =====================================================| >
| > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| >
| > --
| > | From: "James Snape" <jim_snape.at.hotmail.com@.online.nospam>
| > | Subject: AJAX Renderer
| > | Date: Thu, 6 Oct 2005 12:11:52 +0100
| > | Lines: 23
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| > | X-RFC2646: Format=Flowed; Original
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| > | Message-ID: <u0LpGbmyFHA.1256@.TK2MSFTNGP09.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: ip-213-92-131-1.aramiska-arc.aramiska.net
| > 213.92.131.1
| > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl
| > microsoft.public.sqlserver.reportingsvcs:53834
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | I'm in the process of writing a new renderer for Reporting Services to
| > get
| > | around some of the problems it's main HTML renderer has - fixed
headers,
| > | screen flash, losing scroll position on refresh, customisable refresh
| > rate
| > | etc.
| > |
| > | Although it's been fun trying to do this with almost no documentation
at
| > | all, the project is almost at an end. However, there is one last thing
| > I'd
| > | like to implement to make life a little more efficient. That is to
only
| > send
| > | the changes to the client once the original page has been rendered.
| > | Something like Gmail does with it's JavaScript arrays.
| > |
| > | My request is for ideas on how I can create diffs from within the
| > renderer.
| > | Do I need to cache the entire report object model until the next
update
| > | request or is there some easy field in the model to say "it's
changed"?
| > Does
| > | anyone have any other ideas about how I might do this? What is the
best
| > way
| > | of identifying an individual client from within the renderer (my only
| > | current idea is to generate a guid or similar and embed that in the
| > initial
| > | rendering)?
| > |
| > | Regards,
| > | James Snape
| > |
| > |
| > |
| >
|
|
|

AggMerge_ .TMP files eat my harddisk

Hi champs;

This question has already been asked; but still no answer yet on this issue.

When I process the partition I can see that the aggregations are being created. When I look in the file system I see a bunch of .tmp files being created (e.g. AggMerge_5800_54_8s64d_28.tmp), all of them for about 1.0GB. I eventually run out of space on the drive and the processing fails.

All together these .tmp files take about 150GB. The source database is only about 200GB.

Any thoughts? Ideas? The aggregation design wizard tells me the aggregations will take up about 125kb, but the .tmp files tell me something different.

Thanks

kurlan

There are several points here.

One is. You need to take a look at the partition size. You might need to create smaller partitions.

Second. Aggregation design algorithm cannot calculate the size of your aggregations. It only makes size calculations based on the estimated counts on dimension attributes. You might want to create fewer aggregations.

Third. The reason you are seeing temporary files created is: All the aggregations you've designed cannot fit into memory and they are swapped to disc. By decreasing number of aggregations and by making sure you process fewer partitions in parallel, you should be able to achieve a point when aggregation processing does not require swapping.

Here is good source of information about best pracices for partitioning and aggregation creation: http://www.microsoft.com/technet/prodtechnol/sql/2005/realastd.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

again dead lock

hi i m getting below error.

why i m getting this error...

Transaction(Process ID 61) was deadlockeds on lock resources with another process and has been
chosen as the deadlock victim.Return the transaction.82

below is procedure

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

ALTER PROCEDURE Usp_CMSUpdateSchemGroup
(
@.CMS_Upload_Master_ID numeric =null,
@.Maker numeric =null,
@.BnkName varchar(50)=null
)
AS
BEGIN

update Tbl_CMS_UploadDetails
set CMS_SchemeGroup = d.MICR_SchemeGroup
from Tbl_CMS_UploadDetails INNER JOIN
(
Select a.MICR_CMSCode
, a.MICR_SchemeGroup
From Tbl_MICRMst a INNER JOIN
Tbl_BankMst b ON a.MICR_BankName = rtrim(ltrim(b.Bank_Name))
WHERE a.MICR_AuthStatus = 2
and a.MICR_Optype = 0
and b.Bank_isactive=1

) d ON Tbl_CMS_UploadDetails.Scheme_Code = rtrim(ltrim(d.MICR_CMSCode))
where Tbl_CMS_UploadDetails.Scheme_Code = rtrim(ltrim(d.MICR_CMSCode))

declare @.Format_ID numeric
select @.Format_ID=DataFormat_ID from tbl_bankmst where Bank_Name=@.BnkName

print @.Format_ID --+ @.Bank_Name

update Tbl_CMS_UploadDetails
set Maker=@.Maker,
Make_Date=getdate(),
AuthStatus=2,
Optype=0,
Compare_Status ='Pending',
Format_ID=@.Format_ID
Where CMS_Upload_Master_ID=@.CMS_Upload_Master_ID

--Added By Gopal For HDFC Bounce cases 24-Feb-07
Update Tbl_CMS_UploadDetails Set amount =-amount where format_id='83' and drcr ='D' and amount>0 and compare_status='Pending'
Update Tbl_CMS_UploadDetails Set amount =-amount where format_id in('82','83') and rtrim(ltrim(drcr)) ='C' and amount<0 and compare_status='Pending'
Update Tbl_CMS_UploadDetails Set amount =-amount where format_id='82' and rtrim(ltrim(drcr)) ='B' and amount>0 and compare_status='Pending'
--Added by Nachiket for failure

Update Tbl_CMS_UploadDetails Set amount =-amount where format_id in ('89','91','86') and amount>0 and compare_status='Pending'

Update Tbl_CMS_UploadDetails Set amount =abs(amount) where format_id in ('85','88','90') and amount<0 and compare_status='Pending'
Declare @.recCount int
select @.recCount=count(*) from tbl_cms_uploaddetails where CMS_Upload_Master_ID=@.CMS_Upload_Master_ID
update tbl_cms_uploadMaster set rec_count =@.recCount
Where
CMS_Upload_Master_ID=@.Cms_Upload_Master_Id
Declare @.amount decimal
select @.amount=SUM(Amount) from tbl_cms_uploaddetails where CMS_Upload_Master_ID=@.CMS_Upload_Master_ID
update tbl_cms_uploadMaster set Amount =@.amount
Where
CMS_Upload_Master_ID=@.Cms_Upload_Master_Id

END

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

Deadlocking occurs because 2 processes are competing for the same resources like this

Process 1 is holding Table A & is waiting for Table B to complete.

Process 2 is holding Table B & is waiting for Table A to complete.

Neither will let go off the resource it has. SQL Server detects this dead-locking and will randomly choose one to kill.

DBCC TRACEON (3650, 1205, -1) will write the details of the 2 processes of the deadlocking into the errorlog each times that it occurs but the error log can grow very fast.

An easy way to avoid deadlocking is to ensure the all processes access tables in the same order (e.g. Customer, Accounts, Transactions or maybe in alphabetical order if this works for you)

regards,

Niall.

|||hey thanx for reply...but how to solve my problem?|||

You need to run the traceon to find out what the other process (involved in the deadlocking) is doing. Then you can figure out which objects are used by both procedures/routines and how the order of access to these objects might differ.

Once you have that, it can be fixed.

Niall.

After Restore Master DB, User can't logon

Dear all,
My Lab has one SQL Server which used by ApplicationA, during
the installation process of ApplicationA, ApplicationA will
add New Logins for one local user group, and add one domain
useraccount to be a member of this local user group, i want
to simulate disaster rescovery of ApplicationA, so i do the
steps listed bellow:
(1) backup all related SQL database, inclued Master DB Full Backup
(2) Install one new Windows 2003 Server
(3) create local user group used by ApplicationA
(4) Install SQL Server and SP3a in this new Server, and every
installation options is the same as old server
(5) Install ApplicationA
(6) Restore all Database from backup media
(7) make sure no error happend when restore
after restore database, domain user account which is a member
of that local user group can't logon go SQL Server, when use SQL
Query Analyzer, error message appear:
can't connect to server SQLServerName:
Server:Message18456,Level16,Status1
Microsoft][ODBC SQL Server][SQL Server]User'Test\testuser' logon failed
if i delete SQL logins for that local user group, and then new logins
for that local user group, the domain user account can logon successfully,
so i think although the name of local user gorup is the same, but
the sid of local user gorup is different, because this is the new Windows
2003 Server.
Am i right? if i'm right, anything i can do to resolve this problem
thanks for any reply
Rico
Problems about orphaned users ?
http://msdn.microsoft.com/library/de...tabse_0ttf.asp
http://vyaskn.tripod.com/troubleshoo...phan_users.htm
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Rico" <rico_chang@.msn.com> schrieb im Newsbeitrag
news:%23MSOGZhWFHA.1152@.tk2msftngp13.phx.gbl...
> Dear all,
> My Lab has one SQL Server which used by ApplicationA, during
> the installation process of ApplicationA, ApplicationA will
> add New Logins for one local user group, and add one domain
> useraccount to be a member of this local user group, i want
> to simulate disaster rescovery of ApplicationA, so i do the
> steps listed bellow:
> (1) backup all related SQL database, inclued Master DB Full Backup
> (2) Install one new Windows 2003 Server
> (3) create local user group used by ApplicationA
> (4) Install SQL Server and SP3a in this new Server, and every
> installation options is the same as old server
> (5) Install ApplicationA
> (6) Restore all Database from backup media
> (7) make sure no error happend when restore
> after restore database, domain user account which is a member
> of that local user group can't logon go SQL Server, when use SQL
> Query Analyzer, error message appear:
> can't connect to server SQLServerName:
> Server:Message18456,Level16,Status1
> Microsoft][ODBC SQL Server][SQL Server]User'Test\testuser' logon failed
> if i delete SQL logins for that local user group, and then new logins
> for that local user group, the domain user account can logon successfully,
> so i think although the name of local user gorup is the same, but
> the sid of local user gorup is different, because this is the new Windows
> 2003 Server.
> Am i right? if i'm right, anything i can do to resolve this problem
> thanks for any reply
> Rico
>
|||Hi
Yes, the SID is different.
You are in a domain, so why are you using local groups? As you see, in a DR
scenario, it becomes difficult to work with. If this was a cluster, you
would have the same problems.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rico" <rico_chang@.msn.com> wrote in message
news:%23MSOGZhWFHA.1152@.tk2msftngp13.phx.gbl...
> Dear all,
> My Lab has one SQL Server which used by ApplicationA, during
> the installation process of ApplicationA, ApplicationA will
> add New Logins for one local user group, and add one domain
> useraccount to be a member of this local user group, i want
> to simulate disaster rescovery of ApplicationA, so i do the
> steps listed bellow:
> (1) backup all related SQL database, inclued Master DB Full Backup
> (2) Install one new Windows 2003 Server
> (3) create local user group used by ApplicationA
> (4) Install SQL Server and SP3a in this new Server, and every
> installation options is the same as old server
> (5) Install ApplicationA
> (6) Restore all Database from backup media
> (7) make sure no error happend when restore
> after restore database, domain user account which is a member
> of that local user group can't logon go SQL Server, when use SQL
> Query Analyzer, error message appear:
> can't connect to server SQLServerName:
> Server:Message18456,Level16,Status1
> Microsoft][ODBC SQL Server][SQL Server]User'Test\testuser' logon failed
> if i delete SQL logins for that local user group, and then new logins
> for that local user group, the domain user account can logon successfully,
> so i think although the name of local user gorup is the same, but
> the sid of local user gorup is different, because this is the new Windows
> 2003 Server.
> Am i right? if i'm right, anything i can do to resolve this problem
> thanks for any reply
> Rico
>
|||Dear Mike,
thanks for your reply, in fact, ApplicationA means MOM Server 2005,
MOM Server will create some local groups
Rico
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD:uKfxmfhWFHA.3584@.TK2MSFTNGP14.phx.g bl...
> Hi
> Yes, the SID is different.
> You are in a domain, so why are you using local groups? As you see, in a
> DR scenario, it becomes difficult to work with. If this was a cluster, you
> would have the same problems.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Rico" <rico_chang@.msn.com> wrote in message
> news:%23MSOGZhWFHA.1152@.tk2msftngp13.phx.gbl...
>

After Restore Master DB, User can't logon

Dear all,
My Lab has one SQL Server which used by ApplicationA, during
the installation process of ApplicationA, ApplicationA will
add New Logins for one local user group, and add one domain
useraccount to be a member of this local user group, i want
to simulate disaster rescovery of ApplicationA, so i do the
steps listed bellow:
(1) backup all related SQL database, inclued Master DB Full Backup
(2) Install one new Windows 2003 Server
(3) create local user group used by ApplicationA
(4) Install SQL Server and SP3a in this new Server, and every
installation options is the same as old server
(5) Install ApplicationA
(6) Restore all Database from backup media
(7) make sure no error happend when restore
after restore database, domain user account which is a member
of that local user group can't logon go SQL Server, when use SQL
Query Analyzer, error message appear:
can't connect to server SQLServerName:
Server:Message18456,Level16,Status1
Microsoft][ODBC SQL Server][SQL Server]User'Test\testuser' logon fai
led
if i delete SQL logins for that local user group, and then new logins
for that local user group, the domain user account can logon successfully,
so i think although the name of local user gorup is the same, but
the sid of local user gorup is different, because this is the new Windows
2003 Server.
Am i right' if i'm right, anything i can do to resolve this problem
thanks for any reply
RicoProblems about orphaned users ?
http://msdn.microsoft.com/library/d...
tabse_0ttf.asp
http://vyaskn.tripod.com/troublesho...rphan_users.htm
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Rico" <rico_chang@.msn.com> schrieb im Newsbeitrag
news:%23MSOGZhWFHA.1152@.tk2msftngp13.phx.gbl...
> Dear all,
> My Lab has one SQL Server which used by ApplicationA, during
> the installation process of ApplicationA, ApplicationA will
> add New Logins for one local user group, and add one domain
> useraccount to be a member of this local user group, i want
> to simulate disaster rescovery of ApplicationA, so i do the
> steps listed bellow:
> (1) backup all related SQL database, inclued Master DB Full Backup
> (2) Install one new Windows 2003 Server
> (3) create local user group used by ApplicationA
> (4) Install SQL Server and SP3a in this new Server, and every
> installation options is the same as old server
> (5) Install ApplicationA
> (6) Restore all Database from backup media
> (7) make sure no error happend when restore
> after restore database, domain user account which is a member
> of that local user group can't logon go SQL Server, when use SQL
> Query Analyzer, error message appear:
> can't connect to server SQLServerName:
> Server:Message18456,Level16,Status1
> Microsoft][ODBC SQL Server][SQL Server]User'Test\testuser' logon f
ailed
> if i delete SQL logins for that local user group, and then new logins
> for that local user group, the domain user account can logon successfully,
> so i think although the name of local user gorup is the same, but
> the sid of local user gorup is different, because this is the new Windows
> 2003 Server.
> Am i right' if i'm right, anything i can do to resolve this problem
> thanks for any reply
> Rico
>|||Hi
Yes, the SID is different.
You are in a domain, so why are you using local groups? As you see, in a DR
scenario, it becomes difficult to work with. If this was a cluster, you
would have the same problems.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rico" <rico_chang@.msn.com> wrote in message
news:%23MSOGZhWFHA.1152@.tk2msftngp13.phx.gbl...
> Dear all,
> My Lab has one SQL Server which used by ApplicationA, during
> the installation process of ApplicationA, ApplicationA will
> add New Logins for one local user group, and add one domain
> useraccount to be a member of this local user group, i want
> to simulate disaster rescovery of ApplicationA, so i do the
> steps listed bellow:
> (1) backup all related SQL database, inclued Master DB Full Backup
> (2) Install one new Windows 2003 Server
> (3) create local user group used by ApplicationA
> (4) Install SQL Server and SP3a in this new Server, and every
> installation options is the same as old server
> (5) Install ApplicationA
> (6) Restore all Database from backup media
> (7) make sure no error happend when restore
> after restore database, domain user account which is a member
> of that local user group can't logon go SQL Server, when use SQL
> Query Analyzer, error message appear:
> can't connect to server SQLServerName:
> Server:Message18456,Level16,Status1
> Microsoft][ODBC SQL Server][SQL Server]User'Test\testuser' logon f
ailed
> if i delete SQL logins for that local user group, and then new logins
> for that local user group, the domain user account can logon successfully,
> so i think although the name of local user gorup is the same, but
> the sid of local user gorup is different, because this is the new Windows
> 2003 Server.
> Am i right' if i'm right, anything i can do to resolve this problem
> thanks for any reply
> Rico
>|||Dear Mike,
thanks for your reply, in fact, ApplicationA means MOM Server 2005,
MOM Server will create some local groups
Rico
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> glsD:uKfxmfhWFHA.3584@.TK2MSFTNGP14.p
hx.gbl...
> Hi
> Yes, the SID is different.
> You are in a domain, so why are you using local groups? As you see, in a
> DR scenario, it becomes difficult to work with. If this was a cluster, you
> would have the same problems.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Rico" <rico_chang@.msn.com> wrote in message
> news:%23MSOGZhWFHA.1152@.tk2msftngp13.phx.gbl...
>

After Restore Master DB, User can't logon

Dear all,
My Lab has one SQL Server which used by ApplicationA, during
the installation process of ApplicationA, ApplicationA will
add New Logins for one local user group, and add one domain
useraccount to be a member of this local user group, i want
to simulate disaster rescovery of ApplicationA, so i do the
steps listed bellow:
(1) backup all related SQL database, inclued Master DB Full Backup
(2) Install one new Windows 2003 Server
(3) create local user group used by ApplicationA
(4) Install SQL Server and SP3a in this new Server, and every
installation options is the same as old server
(5) Install ApplicationA
(6) Restore all Database from backup media
(7) make sure no error happend when restore
after restore database, domain user account which is a member
of that local user group can't logon go SQL Server, when use SQL
Query Analyzer, error message appear:
can't connect to server SQLServerName:
Server:Message18456,Level16,Status1
Microsoft][ODBC SQL Server][SQL Server]User'Test\testuser' logon failed
if i delete SQL logins for that local user group, and then new logins
for that local user group, the domain user account can logon successfully,
so i think although the name of local user gorup is the same, but
the sid of local user gorup is different, because this is the new Windows
2003 Server.
Am i right' if i'm right, anything i can do to resolve this problem
thanks for any reply
RicoProblems about orphaned users ?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servdatabse_0ttf.asp
http://vyaskn.tripod.com/troubleshooting_orphan_users.htm
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Rico" <rico_chang@.msn.com> schrieb im Newsbeitrag
news:%23MSOGZhWFHA.1152@.tk2msftngp13.phx.gbl...
> Dear all,
> My Lab has one SQL Server which used by ApplicationA, during
> the installation process of ApplicationA, ApplicationA will
> add New Logins for one local user group, and add one domain
> useraccount to be a member of this local user group, i want
> to simulate disaster rescovery of ApplicationA, so i do the
> steps listed bellow:
> (1) backup all related SQL database, inclued Master DB Full Backup
> (2) Install one new Windows 2003 Server
> (3) create local user group used by ApplicationA
> (4) Install SQL Server and SP3a in this new Server, and every
> installation options is the same as old server
> (5) Install ApplicationA
> (6) Restore all Database from backup media
> (7) make sure no error happend when restore
> after restore database, domain user account which is a member
> of that local user group can't logon go SQL Server, when use SQL
> Query Analyzer, error message appear:
> can't connect to server SQLServerName:
> Server:Message18456,Level16,Status1
> Microsoft][ODBC SQL Server][SQL Server]User'Test\testuser' logon failed
> if i delete SQL logins for that local user group, and then new logins
> for that local user group, the domain user account can logon successfully,
> so i think although the name of local user gorup is the same, but
> the sid of local user gorup is different, because this is the new Windows
> 2003 Server.
> Am i right' if i'm right, anything i can do to resolve this problem
> thanks for any reply
> Rico
>|||Hi
Yes, the SID is different.
You are in a domain, so why are you using local groups? As you see, in a DR
scenario, it becomes difficult to work with. If this was a cluster, you
would have the same problems.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rico" <rico_chang@.msn.com> wrote in message
news:%23MSOGZhWFHA.1152@.tk2msftngp13.phx.gbl...
> Dear all,
> My Lab has one SQL Server which used by ApplicationA, during
> the installation process of ApplicationA, ApplicationA will
> add New Logins for one local user group, and add one domain
> useraccount to be a member of this local user group, i want
> to simulate disaster rescovery of ApplicationA, so i do the
> steps listed bellow:
> (1) backup all related SQL database, inclued Master DB Full Backup
> (2) Install one new Windows 2003 Server
> (3) create local user group used by ApplicationA
> (4) Install SQL Server and SP3a in this new Server, and every
> installation options is the same as old server
> (5) Install ApplicationA
> (6) Restore all Database from backup media
> (7) make sure no error happend when restore
> after restore database, domain user account which is a member
> of that local user group can't logon go SQL Server, when use SQL
> Query Analyzer, error message appear:
> can't connect to server SQLServerName:
> Server:Message18456,Level16,Status1
> Microsoft][ODBC SQL Server][SQL Server]User'Test\testuser' logon failed
> if i delete SQL logins for that local user group, and then new logins
> for that local user group, the domain user account can logon successfully,
> so i think although the name of local user gorup is the same, but
> the sid of local user gorup is different, because this is the new Windows
> 2003 Server.
> Am i right' if i'm right, anything i can do to resolve this problem
> thanks for any reply
> Rico
>|||Dear Mike,
thanks for your reply, in fact, ApplicationA means MOM Server 2005,
MOM Server will create some local groups
Rico
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> ¼¶¼g©ó¶l¥ó·s»D:uKfxmfhWFHA.3584@.TK2MSFTNGP14.phx.gbl...
> Hi
> Yes, the SID is different.
> You are in a domain, so why are you using local groups? As you see, in a
> DR scenario, it becomes difficult to work with. If this was a cluster, you
> would have the same problems.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Rico" <rico_chang@.msn.com> wrote in message
> news:%23MSOGZhWFHA.1152@.tk2msftngp13.phx.gbl...
>> Dear all,
>> My Lab has one SQL Server which used by ApplicationA, during
>> the installation process of ApplicationA, ApplicationA will
>> add New Logins for one local user group, and add one domain
>> useraccount to be a member of this local user group, i want
>> to simulate disaster rescovery of ApplicationA, so i do the
>> steps listed bellow:
>> (1) backup all related SQL database, inclued Master DB Full Backup
>> (2) Install one new Windows 2003 Server
>> (3) create local user group used by ApplicationA
>> (4) Install SQL Server and SP3a in this new Server, and every
>> installation options is the same as old server
>> (5) Install ApplicationA
>> (6) Restore all Database from backup media
>> (7) make sure no error happend when restore
>> after restore database, domain user account which is a member
>> of that local user group can't logon go SQL Server, when use SQL
>> Query Analyzer, error message appear:
>> can't connect to server SQLServerName:
>> Server:Message18456,Level16,Status1
>> Microsoft][ODBC SQL Server][SQL Server]User'Test\testuser' logon failed
>> if i delete SQL logins for that local user group, and then new logins
>> for that local user group, the domain user account can logon
>> successfully,
>> so i think although the name of local user gorup is the same, but
>> the sid of local user gorup is different, because this is the new Windows
>> 2003 Server.
>> Am i right' if i'm right, anything i can do to resolve this problem
>> thanks for any reply
>> Rico
>

Advisor Scan Fails

Hey all. I'm in the process of starting an upgrade from SQL2000 to SQL2005. I ran the Upgrade Advisor like suggested and I keep receiving an error.

'Cannot use DSO (Decision Support Objects) to connect to Analysis Services, DSO is either not installed ot the installation is corrupted. Error details: Retrieving the COM class factory for component with CLSID {B492C386-0195-11D2-89BA-00C04FB9898D} failed due to the following error: 80040154.'

Any suggestions or ideas?

Chris

Upgrade Advisor requires DSO. Here is the except from the help files that tells you how to install it.

SQL Server 2000 decision support objects (DSO) are required to scan upgrade issues in Analysis services. To install DSO, insert the SQL Server 2000 media into the CD/DVD drive. This starts the SQL Server 2000 Setup program. Click Install SQL Server 2000 Components. Click Analysis Services to start the Analysis Services Setup program. In Select Components, make sure that the Decision Support Objects component is selected.

Thanks

Michelle