Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL SERVER 2005 auto update statistics , auto shrink

Posted on 2008-10-05
4
Medium Priority
?
1,407 Views
Last Modified: 2010-04-21
Hi Experts Basically i have switched the database properties update statistics,auto shrink to true I want to understand what is the interval SQL server will auto update statistics or auto shrink .is there any interval defined or can user set that timmings.
0
Comment
Question by:Sandeepiii
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 37

Accepted Solution

by:
momi_sabag earned 1200 total points
ID: 22644789
statistics are updated according to the amound of updates done to your data and according to the queries that are performed in your system
0
 

Author Comment

by:Sandeepiii
ID: 22645217
Thanks.that means it is done by sql engine and that time interval cannot be set like once or two times all decision is taken by engine based on amt of work happening.
0
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22657272
exactly
0
 

Author Closing Comment

by:Sandeepiii
ID: 31503181
explanation was very precise and helpful .
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question