Re: Managing Long Running Queries/Batches
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Everything you mentions sounds like good ways to tweak performance for
your SQL server. I would focus on one of two solutions as a relatively
easy and inexpensive ways to achieve your goals.
1) Run the queries asynchonously. One solution I have seen for this is
allow the users to creater their queries, load the SQL into a job and
schedule the job during off hours. Store the job's results in a
uniquely named table (probably in a db that just holds these type of
query results, ideally on a seperate disk) and allow the user to
retrieve that data the next day. For cleanup, define expiration dates,
and/or allow the users to delete their results.
2) Use replication, or better, log shipping to another server where the
queries will be processed. The data will be as up to date as the
replication or log shipping occurs (defined by you). Only the user
defined queries being run on this seperate server will be affected by
any performance issues any of the queries introduce.
Hope that helps.
.
Relevant Pages
- problem with asp web site recorsets (sqlserver2000) return esporadicaly EOF BOF
... intermittently return empty recordsets on queries that should be returning ... At the time the problem occurs, the same queries successfully ... Microsoft SQL Server. ... same sql querys using query analizer, the sql server return valid results. ...
(microsoft.public.data.odbc) - Re: Custom Row Functions: Access vs. SQL Server
... how can I implement the custom row functions? ... >Visual Basic integrated with SQL Server just as it is with Access? ... Custom functions can be used in SQL Server 2000 and above queries, ...
(comp.databases.ms-access) - Re: Alternatives to ADP?
... Another thing to look at, which Sylvain touched on, but didn't quite highlight is to write your queries on the SQL Server side, and ... then attach them in Access as either Tables or Pass-through Queries. ... have the disadvantage that you have to worry about linking them in...not so much a problem if your server is reliably in one place, ... So I am now testing the other upsizing option that creates an adp file. ...
(microsoft.public.access.adp.sqlserver) - Re: NETWORKIO?!?!
... Access 2000 MDE frontend with 4 ODBC linked ... are a few queries, which return all records. ... My problems all started around the time the server was upgraded to 2003 ... Then SQL Server is totally unresponsive. ...
(microsoft.public.access.queries) - Importance of Max Degree of Parallelism in SQL Server
... This setting can be changed at the server level by setting the value to 1, which will prevent parallel execution of all queries fired. ... thejami wrote: ... We have four processors on our SQL Server and want to turn on all four now ... parallelism" configuration option. ...
(microsoft.public.sqlserver.server) |
|
