April 29, 2008 at 1:35 pm
Hi, I have just successfully installed SSIS and SSRS in a server which will be specifically be running Integration and reporting server only.
To keep the performance optimized at all time, I was wondering if I can do something with the Report Server Temp DB here. I am also concern about the growth of it as I know when we hit production, it will go humongous. Please advise as what I can do to keep it high performance and also other things that I should take account into to keep the server up and running at its best.
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
April 29, 2008 at 1:56 pm
The main thing is don't skimp on it. Let TempDB grow. Start out with it pretty big, so it doesn't have to stop and grow all the time.
Pick a size to start out. Something you think is reasonable. Keep an eye on it for a little while. From that, you'll get an idea of how big it can get. Set it to start out a little bigger than that (accommodate future growth), and set a specific increase amount, and you'll be fine.
It can also help if you give the server one tempdb file per CPU. I haven't managed systems active enough for this to matter, but I've read that it matters.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 29, 2008 at 2:01 pm
In addition to GSquared's point - be sure to make the ReportingServicesTempDB BIG. Just like giving tempDB a big playground, ReportingServicesTempDB is going to take up a substantial portion of disk space, since that contains all of the cached data, report snapshots, reporting session viewstates. Meaning - it could have multiple cached copies of large chunks of data out of the databases you're reporting on.
No sense in having the CEO wait for the ReportingServicesTempDB to autogrow, while he is trying to access the financial summary for the year.... You never know - he could be trying to determine your yearly bonus with that figure, so you'd hate for him to have to wait....:)
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
April 29, 2008 at 2:02 pm
Thanks on that........
Is there any specific percentage that I should apply to follow for the size?
Also, this machine is going to be active with Integration Services as well. Is there any other suggestions?
Right now, I don't mind inputs of any kind. I am just collecting to make a good documentation purposes
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply