| Author |
Topic |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2011-09-12 : 19:49:13
|
| We have 2008 Server asMicrosoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor) just due to the LOW RAM Memory the server became little slow, but there were several DB's inside of which 1 db has more frequently transacted.This DB has rose its LDF to almost 20 times to the MDF and (offcourse MDF to small extent) grows on daily basis.Is there any connectivity with RAM to the rising of this Datafiles?Can anyone explains.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2011-09-12 : 19:51:16
|
What does this mean:quote:
there were several DB's inside of which 1 db has more frequently transacted.
There's a small connection between memory and the mdf in that data pages are put in memory. The bigger your database gets and the need for the application to use it, the more memory it'll need/use. What makes you think that low memory availability is connected to your performance issues? Is this a dedicated database server?It doesn't sound like you have proper database maintenance on your transaction log. I think we've been over this topic a few times with you, but please post exactly what you are doing with the tlog in regards to recovery model and backups.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2011-09-12 : 19:56:26
|
| The DB's inside are SIMPLE in Recovery Mode and the backups were daily based.What I want to know is the increase in the LDF as well as MDF (which is ok), but due to low RAM does this LDF increases so rapidly? |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2011-09-12 : 19:57:57
|
| Also this is Dedicated Server on 2008 Platform. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2011-09-12 : 20:00:17
|
| Got clarified now as it seems not a big Change from 2005 to 2008 Platforms interms of this reasoning.Absolutely I need to look into (4). |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2011-09-12 : 20:05:48
|
| Given the Thought under 2008 Platform not doing with INDEX REBUILDS.is this a good or not?Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2011-09-12 : 20:48:59
|
| No (Replication ; Mirroring; REPlication + Mirroring; Index Rebuild)Only Large transactions coming onto Database which is in SIMPLE Recovery.My Direct question is, whether with LOW RAM is anywhere is connected to grow any of the data files?You replied NO.Then obviously with Large transactions.Currently we don't have any performace problems, but is slow; and end-user is not complaining.Now is this large transactions interlinked with low RAM? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-12 : 21:23:43
|
Queries might be slow because you aren't maintaining your indexes either.  |
|
|
|
|
Is RAM linked with Data files