Performance setting for a job

Hello,
I have a script that create some tables with (Select ... Into) for caching
and optimizing. This cache is created twice a w automatically. Problem:
The caching process needs 20 mins and while this 20 mins my website is not
working because SQL Server is busy with 100%.
Is there any chance to tell the SQL-Server that he should not use more than
20% of it's CPU for this job? No problem if it needs longer...
Thanks in advance.
CFIf you have indexes on the tables, drop these before you delete and
re-insert the data, then add the indexes after
It'll be quicker than inserting a huge amount of data into an indexed table.
You might want to consider using triggers or difference/update scripts to
maintain the tables over the course of the day if possible,
but without knowing what the cache tables consist of or how they are
populated it's difficult to say.
"Christian Funke" <ChristianFunke@.discussions.microsoft.com> wrote in
message news:1575B198-0132-46AA-8C32-1590110AA17A@.microsoft.com...
> Hello,
> I have a script that create some tables with (Select ... Into) for caching
> and optimizing. This cache is created twice a w automatically. Problem:
> The caching process needs 20 mins and while this 20 mins my website is not
> working because SQL Server is busy with 100%.
> Is there any chance to tell the SQL-Server that he should not use more
than
> 20% of it's CPU for this job? No problem if it needs longer...
> Thanks in advance.
> CF

performance Problems

I am setting counters for performance monitor and have
about 12 different counters. I have 13 production
servers. How can i create a .msc file and use the same
file for all the servers. Now I think i need to create
each on the server manually.
is there any better way of doing this.
Thanks
AjaOne tool you may want to review is PSSDIAG. It can capture PerfMon, Profiler
and blocking traces.
PSSDIAG data collection utility
http://support.microsoft.com/defaul...kb;en-us;830232
Internal SQL Server Diagnostics Tools, Part 1: PSSDiag
http://msdn.microsoft.com/library/d...ev_12072004.asp
Adrian
"aja" <anonymous@.discussions.microsoft.com> wrote in message
news:08cc01c52e64$3c526fd0$a501280a@.phx.gbl...
>I am setting counters for performance monitor and have
> about 12 different counters. I have 13 production
> servers. How can i create a .msc file and use the same
> file for all the servers. Now I think i need to create
> each on the server manually.
> is there any better way of doing this.
> Thanks
> Aja

performance Problems

I am setting counters for performance monitor and have
about 12 different counters. I have 13 production
servers. How can i create a .msc file and use the same
file for all the servers. Now I think i need to create
each on the server manually.
is there any better way of doing this.
Thanks
Aja
One tool you may want to review is PSSDIAG. It can capture PerfMon, Profiler
and blocking traces.
PSSDIAG data collection utility
http://support.microsoft.com/default...b;en-us;830232
Internal SQL Server Diagnostics Tools, Part 1: PSSDiag
http://msdn.microsoft.com/library/de...v_12072004.asp
Adrian
"aja" <anonymous@.discussions.microsoft.com> wrote in message
news:08cc01c52e64$3c526fd0$a501280a@.phx.gbl...
>I am setting counters for performance monitor and have
> about 12 different counters. I have 13 production
> servers. How can i create a .msc file and use the same
> file for all the servers. Now I think i need to create
> each on the server manually.
> is there any better way of doing this.
> Thanks
> Aja

performance Problems

I am setting counters for performance monitor and have
about 12 different counters. I have 13 production
servers. How can i create a .msc file and use the same
file for all the servers. Now I think i need to create
each on the server manually.
is there any better way of doing this.
Thanks
AjaOne tool you may want to review is PSSDIAG. It can capture PerfMon, Profiler
and blocking traces.
PSSDIAG data collection utility
http://support.microsoft.com/default.aspx?scid=kb;en-us;830232
Internal SQL Server Diagnostics Tools, Part 1: PSSDiag
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqldev/html/sqldev_12072004.asp
Adrian
"aja" <anonymous@.discussions.microsoft.com> wrote in message
news:08cc01c52e64$3c526fd0$a501280a@.phx.gbl...
>I am setting counters for performance monitor and have
> about 12 different counters. I have 13 production
> servers. How can i create a .msc file and use the same
> file for all the servers. Now I think i need to create
> each on the server manually.
> is there any better way of doing this.
> Thanks
> Aja

Performance Opening Report in Preview

Opening the report in preview is very slow, as if the main query is running
without the parameters. Is there a setting to make sure a dataset is not
queried until after the report view button is clicked?Do you have defaults for all the parameters? If so then it runs as soon as
you preview the report. To have it not run until you click on the view
button at least one parameter needs to be without a default.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"WillC" <WillC@.discussions.microsoft.com> wrote in message
news:3578FA47-2646-419F-B683-32E8C70B4622@.microsoft.com...
> Opening the report in preview is very slow, as if the main query is
> running
> without the parameters. Is there a setting to make sure a dataset is not
> queried until after the report view button is clicked?