Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DestinyJack
Starting Member
22 Posts |
 Posted - 2005-09-18 : 23:29:50
|
| Do anyone know when and how the LDF file grows? I am now having a 8GB database with a 10.9GB LDF file.I am importing data from SAS to SQL Server using visual basic .Net. The first few time I encountered some errors so I just terminate the program, and i suspected that this make the LDF file grows to 10GB.Will the large LDF file affect the performance of the database? |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-19 : 02:17:28
|
| an LDF of up to about 120% of the MDF is "okay", so I shouldn't worry about it.That's a bit of a broad brush answer, so if you're still concerned, or it grows some more, then please ask again.It should not impact on performance, but it will slow a RESTORE from backup (although you probably can't realistically make an LDF file much smaller than that)Kristen |
 |
|
|
DestinyJack
Starting Member
22 Posts |
Posted - 2005-09-19 : 06:44:34
|
| Thanks for the reply, Kristen.If it has no impact on the performance then it should be ok to me.Anyway may I ask that if I need to improve my skill in designing a high performance database (better stored procedure, better table design etc), how should I go for it? If I could attend courses, which type of courses should I take? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-19 : 07:04:22
|
| Dunno about training, I'm self taught. We have inbuilt diagnostics in our applications that record start/stop times of SProcs so we can analyse which are the slow running ones etc. SQL Profiler can tell you the same sort of stuff - slow running SProcs/Queries. You could then work on improving those?A lot of it is experience I expect - some of which you can short-circuit by reading answers to posts on SQL Team - so lurking here and reading stuff might help!Kristen |
|
|
|
|
|
|
Some question on the LDF file