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

Re: Increase tempdb database, SQL 2008 R2

From	"Bob Barrows" <reb01501@NOyahooSPAM.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Increase tempdb database, SQL 2008 R2
Date	2011-12-23 09:24 -0500
Organization	A noiseless patient Spider
Message-ID	<jd22vh$ocp$1@dont-email.me> (permalink)
References	(1 earlier) <jct0hl$dis$1@dont-email.me> <jcum1j$66p$1@gregory.bnet.hr> <Xns9FC363373690EYazorman@127.0.0.1> <jcuri7$e6j$1@gregory.bnet.hr> <jcv8m5$27o$1@gregory.bnet.hr>

Show all headers | View raw

m wrote:
> Thanks.
>
> We have 8GB RAM on that SQL server.
>
> What do you think if we limit SQL memory to 6GB, would there be any
> improvment on server performance?
>

I don't know. There might be ... there might not be. It depends on if memory
issues are causing the performance problems.

It sounds like you're just willy-nilly throwing solutions at the server
hoping one of them will luckily solve your problem. You need to do some
monitoring and tracing to find out where your performance bottlenecks really
are. Here are some tools that can help in that regard:
http://pal.codeplex.com/

Install and run the SQL 2008 R2 Best Practices Analyzer
http://blogs.msdn.com/b/psssql/archive/2010/06/20/introducing-the-sql-server-2008-r2-best-practices-analyzer-bpa.aspx

Look at the event logs and see if any IO or memory pressure situations are
being reported.

Do some index analysis and see if there are indexes that can be created that
will help:
http://blogs.msdn.com/b/psssql/archive/2010/06/20/introducing-the-sql-server-2008-r2-best-practices-analyzer-bpa.aspx

or indexes that can be dropped due to lack of use:
https://www.google.com/search?hl=en&safe=active&q=sql+unused+indexes&oq=sql+unused+indexes&aq=f&aqi=g1g-v4g-b5&aql=&gs_sm=e&gs_upl=67889l69117l0l70056l7l7l0l0l0l0l201l798l3.3.1l7l0

Hire a consultant to analyze your system and make recommendations.

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

Thread

Increase tempdb database, SQL 2008 R2 "m" <web12master@gmail.com> - 2011-12-21 16:26 +0100
  Re: Increase tempdb database, SQL 2008 R2 "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-12-21 11:12 -0500
    Re: Increase tempdb database, SQL 2008 R2 "m" <web12master@gmail.com> - 2011-12-22 08:25 +0100
      Re: Increase tempdb database, SQL 2008 R2 Erland Sommarskog <esquel@sommarskog.se> - 2011-12-22 08:45 +0000
        Re: Increase tempdb database, SQL 2008 R2 "m" <web12master@gmail.com> - 2011-12-22 09:59 +0100
          Re: Increase tempdb database, SQL 2008 R2 "m" <web12master@gmail.com> - 2011-12-22 13:43 +0100
            Re: Increase tempdb database, SQL 2008 R2 Erland Sommarskog <esquel@sommarskog.se> - 2011-12-22 23:28 +0100
              Re: Increase tempdb database, SQL 2008 R2 "m" <web12master@gmail.com> - 2011-12-23 09:23 +0100
            Re: Increase tempdb database, SQL 2008 R2 "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-12-23 09:24 -0500
      Re: Increase tempdb database, SQL 2008 R2 "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2011-12-22 06:17 -0500
  Re: Increase tempdb database, SQL 2008 R2 Erland Sommarskog <esquel@sommarskog.se> - 2011-12-21 23:36 +0100

csiph-web