Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1416

Re: Elementary management of many indexes, best practice?

Show all headers | View raw

 (rja.carnegie@gmail.com) writes:
> OK... so there aren't any hotfixes or cumulative updates that 
> you'd install as standard?  I know we're not /supposed/ to do
> that.

There are certainly a couple of CU after SP4. Exactly how many I don't
know, nor whether how critical they are.
 
> A problem that we have currently, that may be associated with a 
> particular query, seems to lead to tempdb suddenly inflating to
> over 250 gigabytes - the size of the separate partition that 
> someone with unusual forethought placed it on.  We think this
> is a completely unreasonable effect.

Looks like this query needs tuning.
 
> The trouble that I see with that is that our EIS team only has 
> one SQL server - no, don't leave...  The tuning process is liable to 
> block normal use of the server (uh, right?), particularly if you're
> tuning for a query where performance stinks.

Not really. You a trace during the day, and then you feed that to DTA.
Since this is reports for bosses, maybe you should run it for a week
or so, as there might be a daily pattern which is strong enough.
 
> My impression has been that tuning recommendations should be treated
> as alternatives to choose from, rather than a prescribed remedy;
> I seem to be told to create several indexes and statistics that 
> are quite similar.  But perhaps that's a result of asking the tool
> about just one query - it calculates anything that will help that?

Exactly! You feed it a workload, and if you lie and say that this 
single query is your workload, it will comply.




-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Elementary management of many indexes, best practice? rja.carnegie@gmail.com - 2013-03-12 07:48 -0700
  Re: Elementary management of many indexes, best practice? Erland Sommarskog <esquel@sommarskog.se> - 2013-03-12 22:36 +0100
    Re: Elementary management of many indexes, best practice? rja.carnegie@gmail.com - 2013-03-15 19:23 -0700
      Re: Elementary management of many indexes, best practice? Erland Sommarskog <esquel@sommarskog.se> - 2013-03-16 12:32 +0100
        Re: Elementary management of many indexes, best practice? rja.carnegie@gmail.com - 2013-03-16 14:12 -0700
          Re: Elementary management of many indexes, best practice? Erland Sommarskog <esquel@sommarskog.se> - 2013-03-16 23:08 +0100
      Re: Elementary management of many indexes, best practice? Mark D Powell <Mark.Powell2@hp.com> - 2013-03-27 11:20 -0700

csiph-web