Tempdb Affects Query Performance During Autogrow

Rating:

(0)

Brian Moran

SQL Server Magazine

InstantDoc ID #45154

The execution time for a particular stored procedure increases 500 percent when we restart SQL Server. Our tests account for the effect of data caching, and the stored procedure's execution plan doesn't change. We don't see drops in performance from our other stored procedures, and the slow procedure's performance returns to normal eventually. How can we tune the slow procedure's performance?

...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Still confused! Do we need to set auto grow to True or set a size and set auto grow to False? Thanks

Gad3/23/2007 5:52:34 PM

I still dont understand what you are trying to say. You dont want us to set the size of tempdb to certain thaing, and dont want to user autogrow..please clarify, if I still need to use auto grow or set a size at which it should start.

Jay2/23/2005 5:02:35 PM

I thought the tempdb received it's initial settings from the size of the model database. Am I wrong?

BURTON2/16/2005 11:13:01 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

Related Resources

Tuna Helper - Tuning SQL Statements: A Proven Process for SQL Server Environments
A White Papers by Confio

A Business Case for Lowering Enterprise Total Cost of Ownership - Microsoft SQL Server for SAP on HP Integrity Servers
A White Papers by Hewlett-Packard

The Essential Guide to Mission-Critical Microsoft SQL Server
A Essential Guides by EMC

SSIS Performance Tuning, Connecting to Heterogeneous Sources, and Complex Transformations
A White Papers by expressor software

Field level security

I need to secure certain fields, Name, SSN, for example, in a table's rows. I know about SQL encryption, but is there another way to secure the indiv...