Few Issues

I am sorry to put so many issues at one go.
1. I have just upgraded one of our production dbs(sql 2000) with
latest service packs( change from 3 to 4) and others hot fixes.Also
upgraded the 2003 WIN2k box with all the hot fixes. Since after,all my
processing is taking almost double time to complete.We have processings
which runs thrice a day , which pulls/massages data from our central
db.I did identify few store procs which are running very slowly.My
question.
a)Did any one face this issue before , and if yes, could anyone list
where all it could have got affected?
b) What all non-db related things i should be looking at?
2.I have a sqlserver(2000) box( win 2k3) with 8GB of RAM. I abe
configured it to use 6GB of RAM through dynamic memory management.I
have also enabled the AWE option. My question is do i stil have to
include /pae switch in the boot.ini file.3GB /PAE switch comes into
picture when i have 4 GB of RAM(certain versions) , and it gives me
that extra 1 GB. BUt when i have 8GB , it is AWE Enabled , then what
extra benefit do i get by adding this switch? Does AWE depends on PAE
switch to fucntion normally. AWE infact takes all the memory space
(except 128 MB for OS to work).SO why do i add 3GB /PAE switch to tell
OS to give me 1 extra GB more when AWE( it takes the entire memory and
not just only 1 GB more does that for me.
3. How do i know when was the last time my index was rebuilt/updated.(
may be recreate or may be using dbccreindex).i tried DBCC show update
statiscs, it does show something called last updated. What i know this
shows, when the statistics were last updated( mine is auto update).So
if i run dbcc reindex will the last updated value changeFor future posts, you might want to post each Q independently, to keep each topic in a separate
thread. :-)
2) AWE depends on OS AWE. It is a no-op to sp_configure AWE without setting PAE in BOOT.INI. You can
still decide whether to have 2 or 3 GB "normally" addressable memory using the /3GB switch. The
recommendation is not to have /3GB if you have > some 12-16GB memory in the machine (as overhead of
managing that amount of memory comes from what is left from 4GB minus 2 or 3 GB).
3) That information is not stored anywhere. Why is it important to you?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<shuvam_roy@.yahoo.com> wrote in message news:1127221805.482833.46720@.g49g2000cwa.googlegroups.com...
>I am sorry to put so many issues at one go.
> 1. I have just upgraded one of our production dbs(sql 2000) with
> latest service packs( change from 3 to 4) and others hot fixes.Also
> upgraded the 2003 WIN2k box with all the hot fixes. Since after,all my
> processing is taking almost double time to complete.We have processings
> which runs thrice a day , which pulls/massages data from our central
> db.I did identify few store procs which are running very slowly.My
> question.
> a)Did any one face this issue before , and if yes, could anyone list
> where all it could have got affected?
> b) What all non-db related things i should be looking at?
> 2.I have a sqlserver(2000) box( win 2k3) with 8GB of RAM. I abe
> configured it to use 6GB of RAM through dynamic memory management.I
> have also enabled the AWE option. My question is do i stil have to
> include /pae switch in the boot.ini file.3GB /PAE switch comes into
> picture when i have 4 GB of RAM(certain versions) , and it gives me
> that extra 1 GB. BUt when i have 8GB , it is AWE Enabled , then what
> extra benefit do i get by adding this switch? Does AWE depends on PAE
> switch to fucntion normally. AWE infact takes all the memory space
> (except 128 MB for OS to work).SO why do i add 3GB /PAE switch to tell
> OS to give me 1 extra GB more when AWE( it takes the entire memory and
> not just only 1 GB more does that for me.
>
> 3. How do i know when was the last time my index was rebuilt/updated.(
> may be recreate or may be using dbccreindex).i tried DBCC show update
> statiscs, it does show something called last updated. What i know this
> shows, when the statistics were last updated( mine is auto update).So
> if i run dbcc reindex will the last updated value change
>|||Thanks a lot TIBOR...next tiem will post different questions on
different threads.
BTW any idea baout the first one.?|||You're welcome... :-)
As for the first one, I can't say. My first guess would be to check the execution plans for the
queries involved...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<shuvam_roy@.yahoo.com> wrote in message
news:1127229172.480279.256450@.g49g2000cwa.googlegroups.com...
> Thanks a lot TIBOR...next tiem will post different questions on
> different threads.
> BTW any idea baout the first one.?
>

Failure sending email in subscriptions

I am running SQL 2005, I have the latest service pack on SQL 2005 and also on
the Windows 2003 server. This is on a single server. I am using my Exchange
2003 server as my SMTP server which is on a different server with the same
subnet.
-When a domain user schedules a subscription it won't send an email.
-When a domain admin schdules a subscription the email will get sent.
-When a domain user schedules a subscription with ONLY the link option, it
will send an email and the user can access the link.
- I tried setting my RS config to use Local System and also Network Service,
and that did not make a difference.
In the RS logs I get the error...
Success: False, Status: Failure sending mail: The report server has
encountered a configuration error. See the report server log files for more
information., DeliveryExtension: Report Server Email, Report: Purchase
Requests Ordered But Not Received, Attempt 0
I also get an error in the Windows event log when a subscription is created
or editted, but I'm not sure if it is related. The error is..
Report Server (MSSQLSERVER) cannot load the Report Server DocumentLibrary
extension.
Here is my RS config file..
<RSEmailDPConfiguration>
<SMTPServer>192.168.100.200</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>hqjobs01Reports@.trinitystairs.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>False</SendEmailToUserAlias>
<DefaultHostName>trinitystairs.com</DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
Please Help!Having the same problem. Tried everything and nothing worked. Next week I
will try transferring all my services to run under domain admin account to
see if that helps.
These are some of the links where I have explained my problem. Read just to
make sure that we have same problem.
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1769187&SiteID=17
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.opsmgr.reporting&mid=c1fdce30-5db0-487d-931e-1e17cb0c387b
"Pablo" wrote:
> I am running SQL 2005, I have the latest service pack on SQL 2005 and also on
> the Windows 2003 server. This is on a single server. I am using my Exchange
> 2003 server as my SMTP server which is on a different server with the same
> subnet.
> -When a domain user schedules a subscription it won't send an email.
> -When a domain admin schdules a subscription the email will get sent.
> -When a domain user schedules a subscription with ONLY the link option, it
> will send an email and the user can access the link.
> - I tried setting my RS config to use Local System and also Network Service,
> and that did not make a difference.
> In the RS logs I get the error...
> Success: False, Status: Failure sending mail: The report server has
> encountered a configuration error. See the report server log files for more
> information., DeliveryExtension: Report Server Email, Report: Purchase
> Requests Ordered But Not Received, Attempt 0
>
> I also get an error in the Windows event log when a subscription is created
> or editted, but I'm not sure if it is related. The error is..
> Report Server (MSSQLSERVER) cannot load the Report Server DocumentLibrary
> extension.
> Here is my RS config file..
> <RSEmailDPConfiguration>
> <SMTPServer>192.168.100.200</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing>2</SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>hqjobs01Reports@.trinitystairs.com</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> <RenderingExtension>RGDI</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>False</SendEmailToUserAlias>
> <DefaultHostName>trinitystairs.com</DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
>
> Please Help!