Loading ...
Sorry, an error occurred while loading the content.

Need documents on Database Testing

Expand Messages
  • nilesh babar
    Hi All, If anybody have a documents on Database Testing in .pdf format or any sites where i will get info please let me know. Also if anybody knows Training
    Message 1 of 1 , Dec 14, 2006
    • 0 Attachment
      Hi All,

      If anybody have a documents on Database Testing in .pdf format or any sites where i will get info please let me know. Also if anybody knows Training Institute in Bangalore where i will get Database Testing Training please inform me.

      Thanks in Advance.

      Regards,
      Nilesh

      ----- Original Message ----
      From: "tgray@..." <tgray@...>
      To: SQLQueriesNoCode@yahoogroups.com
      Sent: Friday, 8 December, 2006 10:56:45 PM
      Subject: RE: [SQLQueriesNoCode] Transaction log growing too large













      Just a quick point of clarity: Truncating a table is a non-logged

      operation, so it wouldn't affect the transaction log, correct?



      Tracey Gray

      Database Administrator

      Dairy Farmers of America

      ' 417 829-3640

      + tgray@dfamilk. com



      "John Warner" <john@jwarner. com>

      Sent by: SQLQueriesNoCode@ yahoogroups. com

      12/08/2006 11:10 AM

      Please respond to

      SQLQueriesNoCode@ yahoogroups. com



      To

      <SQLQueriesNoCode@ yahoogroups. com>

      cc



      Subject

      RE: [SQLQueriesNoCode] Transaction log growing too large



      If your development and testing goes like most of us have experienced in

      the past, a log of huge proportions is not unusual if you aren't doing

      log maintenance (Truncate Log -- see books online). When you drop tables

      or truncate a table etc as part of development, you are creating lots of

      log entries. In production this rate of activity will likely be less.



      But there is no substitute for spending a little time reading through

      Books Online for your version of SQL Server and learning what is going

      on first hand (that way you can support your users).



      John Warner



      > -----Original Message-----

      > From: SQLQueriesNoCode@ yahoogroups. com

      > [mailto:SQLQueriesNoCode@ yahoogroups. com] On Behalf Of robert sackey

      > Sent: Friday, December 08, 2006 10:44 AM

      > To: SQLQueriesNoCode@ yahoogroups. com

      > Subject: Re: [SQLQueriesNoCode] Transaction log growing too large

      >

      >

      > Thanks Stephen,

      >

      > So if I got what you are saying, you mean it is normal for

      > the log to grow that rapid during the development stages. And

      > you also mean that withing a period of 4 months, that growth

      > is even smaller? Please clarify Stephen

      >

      >

      >

      > ----- Original Message ----

      > From: Stephen Russell <srussell@lotmate. com>

      > To: SQLQueriesNoCode@ yahoogroups. com

      > Sent: Friday, December 8, 2006 2:58:21 PM

      > Subject: RE: [SQLQueriesNoCode] Transaction log growing too large

      >

      >

      >

      >

      >

      >

      >

      >

      >

      >

      >

      >

      >

      > Truncate table and repopulations will make your

      > log file grow big time.

      >

      >

      >

      > Changing table layouts, and all the other testing that

      > actually goes back to

      >

      > the db will find it's way into the log.

      >

      >

      >

      > Depending on the volume of testing that sounds small for that

      > length of time

      >

      > for that size of the db. So you may be testing at a less

      > rate then I would

      >

      > stress test at.

      >

      >

      >

      >

      >

      > Stephen Russell

      >

      > DBA / .Net Developer

      >

      >

      >

      > Memphis TN 38115

      >

      > 901.246-0159

      >

      >

      >

      > "Our scientific power has outrun our spiritual power. We have guided

      >

      > missiles and misguided men."

      >

      > Dr. Martin Luther King Jr.

      >

      >

      >

      > HYPERLINK

      >

      > "http://spaces. msn.com/members/ srussell/"http://spaces.

      > msn.com/members/ sruss

      >

      > ell/

      >

      >

      >

      > _____

      >

      >

      >

      > From: robert sackey [mailto:papsac@ yahoo. com]

      >

      > Sent: Friday, December 08, 2006 1:51 AM

      >

      > To: SQLQueriesNoCode@ yahoogroups. com

      >

      > Subject: [SQLQueriesNoCode] Transaction log growing too large

      >

      >

      >

      > Hi all,

      >

      >

      >

      > Can anybody explain to me the causes of log file growing so large

      >

      > within a short period? We are in the development stage of ab

      >

      > application so all we enter into the database are test data during

      >

      > development. But the log file within 4 months grew to about

      > 8GB.We have

      >

      > not put the application into production yet. This is quite

      > worrying and

      >

      > I want to be sure what may be causing this and how to resolve this.

      >

      >

      >

      > The application has quite a number of stored procedures.Could

      > that also be a

      >

      > cause?

      >

      >

      >

      > Thanks



      [Non-text portions of this message have been removed]














      <!--

      #ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans-serif;}
      #ygrp-mlmsg table {font-size:inherit;font:100%;}
      #ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-serif;}
      #ygrp-mlmsg pre, code {font:115% monospace;}
      #ygrp-mlmsg * {line-height:1.22em;}
      #ygrp-text{
      font-family:Georgia;
      }
      #ygrp-text p{
      margin:0 0 1em 0;
      }
      #ygrp-tpmsgs{
      font-family:Arial;
      clear:both;
      }
      #ygrp-vitnav{
      padding-top:10px;
      font-family:Verdana;
      font-size:77%;
      margin:0;
      }
      #ygrp-vitnav a{
      padding:0 1px;
      }
      #ygrp-actbar{
      clear:both;
      margin:25px 0;
      white-space:nowrap;
      color:#666;
      text-align:right;
      }
      #ygrp-actbar .left{
      float:left;
      white-space:nowrap;
      }
      .bld{font-weight:bold;}
      #ygrp-grft{
      font-family:Verdana;
      font-size:77%;
      padding:15px 0;
      }
      #ygrp-ft{
      font-family:verdana;
      font-size:77%;
      border-top:1px solid #666;
      padding:5px 0;
      }
      #ygrp-mlmsg #logo{
      padding-bottom:10px;
      }

      #ygrp-vital{
      background-color:#e0ecee;
      margin-bottom:20px;
      padding:2px 0 8px 8px;
      }
      #ygrp-vital #vithd{
      font-size:77%;
      font-family:Verdana;
      font-weight:bold;
      color:#333;
      text-transform:uppercase;
      }
      #ygrp-vital ul{
      padding:0;
      margin:2px 0;
      }
      #ygrp-vital ul li{
      list-style-type:none;
      clear:both;
      border:1px solid #e0ecee;
      }
      #ygrp-vital ul li .ct{
      font-weight:bold;
      color:#ff7900;
      float:right;
      width:2em;
      text-align:right;
      padding-right:.5em;
      }
      #ygrp-vital ul li .cat{
      font-weight:bold;
      }
      #ygrp-vital a {
      text-decoration:none;
      }

      #ygrp-vital a:hover{
      text-decoration:underline;
      }

      #ygrp-sponsor #hd{
      color:#999;
      font-size:77%;
      }
      #ygrp-sponsor #ov{
      padding:6px 13px;
      background-color:#e0ecee;
      margin-bottom:20px;
      }
      #ygrp-sponsor #ov ul{
      padding:0 0 0 8px;
      margin:0;
      }
      #ygrp-sponsor #ov li{
      list-style-type:square;
      padding:6px 0;
      font-size:77%;
      }
      #ygrp-sponsor #ov li a{
      text-decoration:none;
      font-size:130%;
      }
      #ygrp-sponsor #nc {
      background-color:#eee;
      margin-bottom:20px;
      padding:0 8px;
      }
      #ygrp-sponsor .ad{
      padding:8px 0;
      }
      #ygrp-sponsor .ad #hd1{
      font-family:Arial;
      font-weight:bold;
      color:#628c2a;
      font-size:100%;
      line-height:122%;
      }
      #ygrp-sponsor .ad a{
      text-decoration:none;
      }
      #ygrp-sponsor .ad a:hover{
      text-decoration:underline;
      }
      #ygrp-sponsor .ad p{
      margin:0;
      }
      o {font-size:0;}
      .MsoNormal {
      margin:0 0 0 0;
      }
      #ygrp-text tt{
      font-size:120%;
      }
      blockquote{margin:0 0 0 4px;}
      .replbq {margin:4;}
      -->









      ___________________________________________________________
      All New Yahoo! Mail � Tired of Vi@gr@! come-ons? Let our SpamGuard protect you. http://uk.docs.yahoo.com/nowyoucan.html

      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.