f



Log Explorer vs. ApexSQL Log vs. SQL Log-Rescue

Opinions?

I've installed all three to try'em out and they all seem to be working
so far, more or less.

Log Explorer has given me a couple of errors but I started over and
continued OK.

ApexSQL Log squawked about "redo for delete cannot be generated for
tables lacking clustered index". Huh? What the...? We have lots of
tables without a clustered index.

I read some reports in Red-Gate's technical support forum about their
product actually bringing down SQL Server. That did not inspire
confidence.

All three install some server-side components like extended stored
proc's which I'm not crazy about and I think all three are server or
instance licensed (does anyone actually purchase more than one license
when it seems like you can easily move any tran log to be analyzed to
the server the product is installed on?). I don't think I'd want to
install any of them on a Production server, at least one that I'm
responsible for!


Thanks,

Martin

0
mvirta1 (4)
6/8/2006 1:52:04 PM
comp.databases.ms-sqlserver 14567 articles. 1 followers. janinepelletier (108) is leader. Post Follow

1 Replies
864 Views

Similar Articles

[PageSpeed] 32

Martin (mvirta@olgc.ca) writes:
> ApexSQL Log squawked about "redo for delete cannot be generated for
> tables lacking clustered index". Huh? What the...? We have lots of
> tables without a clustered index.
 
Probably the people at ApexSQL are like me: they think that every table
should have a clustered index.

If nothing else, fragmentation is easier to keep in check, if you have
a clustered index.


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
0
esquel (7068)
6/8/2006 9:44:00 PM
Reply:

Similar Artilces:

Logging Who Logs In
How can I keep track of who logs into my ASE (15.0.2)? Thanks, Steve -- Steven J. Backus Computer Specialist University of Utah E-Mail: steven.backus@utah.edu Genetic Epidemiology Alternate: backus@math.utah.edu 391 Chipeta Way -- Suite D Office: 801.587.9308 Salt Lake City, UT 84108-1266 http://www.math.utah.edu/~backus Hello, Enable auditing: http://infocenter.sybase.com/help/topic/com.sybase.help.ase_15.0.sag1/html/sag1/sag1831.htm Thanks, Neal On Dec 3, 9:04=A0pm, bac...@episun7.med.utah.edu (Steven Backus) wrote: > How can I keep track of who logs into my ASE (15.0.2)? > You can setup auditing to find out who logged in when. You can also find out who did what ! here is the ASE manual link.. http://tinyurl.com/5be3oe -HTH Manish Negandhi [TeamSybase] "Steven Backus" <backus@episun7.med.utah.edu> wrote in message news:gh6all$pga@episun7.med.utah.edu... > How can I keep track of who logs into my ASE (15.0.2)? > > Thanks, > Steve > -- > Steven J. Backus Computer Specialist > University of Utah E-Mail: steven.backus@utah.edu > Genetic Epidemiology Alternate: backus@math.utah.edu > 391 Chipeta Way -- Suite D Office: 801.587.9308 > Salt Lake City, UT 84108-1266 http://www.math.utah.edu/~ba...

logging buffered vs. logging history
Hi, could anybody explain the differences between logging buffered and logging history? I need the commands only to store the syslogs at my devices, not to send the messages, as SNMP-Traps, to the NMS. Regards, Christian In article <1139147869.970910.220960@o13g2000cwo.googlegroups.com>, Christian Roos <christian_roos@web.de> wrote: >could anybody explain the differences between logging buffered and >logging history? I need the commands only to store the syslogs at my >devices, not to send the messages, as SNMP-Traps, to the NMS. You did not mention the platform invo...

log file sync vs log file parallel write
Hello all, While investigating performance problems in a database I discovered that the 'log file sync' wait event is almost always in the top 5. (I am looking at the statspack datat) Calculating the ratio of the average wait time of the 'log file sync' and the 'log file parallel write' gives a ratio of 10. Does someone know why this may happen? Regards Hans-Peter On 3 okt, 12:31, HansP <hans-peter.sl...@atosorigin.com> wrote: > Hello all, > > While investigating performance problems in a database I discovered > that the 'log file sync' wait event is almost always in the top 5. > (I am looking at the statspack datat) > > Calculating the ratio of the average wait time of the 'log file sync' > and the 'log file parallel write' =A0gives =A0a ratio of 10. > > Does someone know why this may happen? > > Regards Hans-Peter First of all, 'Log file sync' is associated with commit. If you see this event in the top 5, you are committing way too often (maybe for every individual record) and it is developer beating time!!! They don't know what a transaction is, and they need to be whipped for that. Secondly 'log file parallel write' obviously deals with flushing out the redo log buffer to disk. This means your disks are too slow, or you have an I/O bottleneck. Please note there is plethora of resources on 'log file sync' online, particularly in this very forum. Pl...

log file sync vs log file parallel write probably not bug 2669566
This is a continuation of a previous thread about =91log file sync=92 and =91log file parallel write=92 events. Version : 9.2.0.8 Platform : Solaris Application : Oracle Apps The number of commits per second ranges between 10 and 30. When querying statspack performance data the calculated average wait time on the event =91log file sync=92 is on average 10 times the wait time for the =91log file parallel write=92 event. Below just 2 samples where the ratio is even about 20. "snap_time" " log file parallel write avg" "log file sync avg" "ratio 11/05/2008 10:38:26 8,142 156,343 19.20 11/05/2008 10:08:23 8,434 201,915 23.94 So the wait time for a =91log file sync=92 is 10 times the wait time for a =91log file parallel write=92. First I thought that I was hitting bug 2669566. But then Jonathan Lewis is blog pointed me to Tanel Poder=92s snapper tool. And I think that it proves that I am NOT hitting this bug. Below is a sample of the output for the log writer. -- End of snap 3 HEAD,SID, SNAPSHOT START ,SECONDS,TYPE,STATISTIC , DELTA, DELTA/SEC, HDELTA, HDELTA/SEC DATA, 4, 20081105 10:35:41, 30, STAT, messages sent , 1712, 57, 1.71k, 57.07 DATA, 4, 20081105 10:35:41, 30, STAT, messages received , 866, 29, 866, 28.87 DATA, 4, 20081105 10:35:41, 30, STAT, background timeouts , 10, 0, ...

gdm: how do I log who logs in?
Hi All, Is there a way to have gmd log who logs in and when they logged back out? Not having much luck Googling this. :-( Many thanks, -T # ls -al /var/log/gdm .... -rw-r--r-- 1 root root 1132 May 4 08:31 :0.log -rw-r--r-- 1 root root 1132 Apr 19 19:24 :0.log.1 -rw-r--r-- 1 root root 1132 Apr 19 16:37 :0.log.2 -rw-r--r-- 1 root root 1187 Apr 19 16:37 :0.log.3 -rw-r--r-- 1 root root 1132 Apr 11 08:14 :0.log.4 Note that my logs files are all one byte long. On May 4, 2011 14:50, in comp.os.linux.misc, Todd@invalid.com wrote: > Hi All, > > Is there a way to have gmd log who...

logging cannot access log
i have applied the recent solaris 8 recommended and security cluster patches on sun solaris 8 i rebooted to get the patches applied,but am not able to mount / in rw mode Kernel version: SunOS 5.8 Generic 108528-23 Jun 2003 mount -o remount,rw / WARNING: Could not access the log for /; Please run fsck(1M) mount: No such device mount: cannot mount /dev/md/dsk/d30 vfstab entry /dev/md/dsk/d30 /dev/md/rdsk/d30 / ufs 1 no logging fsck -y / ** /dev/md/rdsk/d30 ** Last Mounted on / ** Phase 1 - Check Blocks and Sizes ** Phase 2 - Check Pathnames ** Phase 3 - Che...

display logged in and logged out
Dear friends, I am having a doubt. How can i display the listof users who have logged in and logged out with in the given time. On Mon, 13 Mar 2006 22:35:56 -0800, balasam wrote: > Dear friends, > I am having a doubt. > How can i display the listof users who have logged > in and logged out with in the given time. Process the output of the "last" command. ...

log file sync vs log file parallel write probably not bug 2669566 #2
This is a continuation of a previous thread about =91log file sync=92 and =91log file parallel write=92 events. Version : 9.2.0.8 Platform : Solaris Application : Oracle Apps The number of commits per second ranges between 10 and 30. When querying statspack performance data the calculated average wait time on the event =91log file sync=92 is on average 10 times the wait time for the =91log file parallel write=92 event. Below just 2 samples where the ratio is even about 20. "snap_time" " log file parallel write avg" "log file sync avg" "ratio 11/05/2008 10:38:26 8,142 156,343 19.20 11/05/2008 10:08:23 8,434 201,915 23.94 So the wait time for a =91log file sync=92 is 10 times the wait time for a =91log file parallel write=92. First I thought that I was hitting bug 2669566. But then Jonathan Lewis is blog pointed me to Tanel Poder=92s snapper tool. And I think that it proves that I am NOT hitting this bug. Below is a sample of the output for the log writer. -- End of snap 3 HEAD,SID, SNAPSHOT START ,SECONDS,TYPE,STATISTIC , DELTA, DELTA/SEC, HDELTA, HDELTA/SEC DATA, 4, 20081105 10:35:41, 30, STAT, messages sent , 1712, 57, 1.71k, 57.07 DATA, 4, 20081105 10:35:41, 30, STAT, messages received , 866, 29, 866, 28.87 DATA, 4, 20081105 10:35:41, 30, STAT, background timeouts , 10, 0, ...

log file sync vs log file parallel write probably not bug 2669566 #3
This is a continuation of a previous thread about =91log file sync=92 and =91log file parallel write=92 events. Version : 9.2.0.8 Platform : Solaris Application : Oracle Apps The number of commits per second ranges between 10 and 30. When querying statspack performance data the calculated average wait time on the event =91log file sync=92 is on average 10 times the wait time for the =91log file parallel write=92 event. Below just 2 samples where the ratio is even about 20. "snap_time" " log file parallel write avg" "log file sync avg" "ratio 11/05/2008 10:38:26 8,142 156,343 19.20 11/05/2008 10:08:23 8,434 201,915 23.94 So the wait time for a =91log file sync=92 is 10 times the wait time for a =91log file parallel write=92. First I thought that I was hitting bug 2669566. But then Jonathan Lewis is blog pointed me to Tanel Poder=92s snapper tool. And I think that it proves that I am NOT hitting this bug. Below is a sample of the output for the log writer. -- End of snap 3 HEAD,SID, SNAPSHOT START ,SECONDS,TYPE,STATISTIC , DELTA, DELTA/SEC, HDELTA, HDELTA/SEC DATA, 4, 20081105 10:35:41, 30, STAT, messages sent , 1712, 57, 1.71k, 57.07 DATA, 4, 20081105 10:35:41, 30, STAT, messages received , 866, 29, 866, 28.87 DATA, 4, 20081105 10:35:41, 30, STAT, background timeouts , 10, 0, ...

Re: (1234*(2/3)^(Log[1234]/Log[3])) === (1234^(Log[2]/Log[3])) should be?
The result should be False. If you want True then you should use Equal ( == ) not SameQ ( === ) (1234*(2/3)^(Log[1234]/Log[3])) == (1234^(Log[2]/Log[3])) // Simplify True Bob Hanlon ---- Luka Rahne <luka.rahne@gmail.com> wrote: ============= what should be result of this evaluation? (1234*(2/3)^(Log[1234]/Log[3])) === (1234^(Log[2]/Log[3])) subqestion. How to make this work? ...

MS SQL Express Advanced vs MS SQL full version vs MySQL
I'm planning to transport a desktop application to the web. A spin-off of this application has already been put on the web by another programmer. He used ColdFusion with MS SQL, Access, VC, and Java. It is faster than the desktop application (written in VFP). 1. Can I get the same results using MS SQL Express Advanced and Access for the internet version if used with .net? 2. Are the select statements limited in power, accuracy, size, etc. for MS SQL Express Advanced when compared to SQL? 3. If Access will perform poorly, can VFP be used instead with .net? I already know it can't be used with ColdFusion. 4. If MS Express Advanced will not sufficiently replace SQL, will MySQL do the job better? Thanks On Jul 22, 5:31 pm, <wipeou...@hotmail.com> wrote: > I'm planning to transport a desktop application to the web. A spin-off of > this application has already been put on the web by another programmer. He > used ColdFusion with MS SQL, Access, VC, and Java. It is faster than the > desktop application (written in VFP). > 1. Can I get the same results using MS SQL Express Advanced and Access for > the internet version if used with .net? > 2. Are the select statements limited in power, accuracy, size, etc. for MS > SQL Express Advanced when compared to SQL? > 3. If Access will perform poorly, can VFP be used instead with .net? I > already know it can't be used with ColdFusion. 4. If MS Express Advanced > will not suffic...

SIMS
Hi, Briefly, my question: does anyone here know the best way to implement all of these (Integrity Checks, Servers Monitoring and Remote Logging) in a mixed environment (UNIX/Windows), everything being open-source ? Details of the question: I am looking for open-source products to secure our network and servers, which are a mix of Windows/Linux/AIX. I am looknig for some help in deciding what products to implement. 1- I want to begin by implementing an integrity checker. I am looking at Samhain and Osiris. Samhain seems better, but since it does not support Windows, I will probably use Osiris. 2- I want to run Nagios on my servers for monitoring 3- I want to setup my UNIX and Windows servers with remote logging. For the UNIX/Linux servers, I would do remote syslogging to a syslog server such as Syslog-ng or Rsyslog. For the Windows servers, I would also setup a remote logging to that same syslog server, with a client tool such as Winsyslog. 4- On top of that, I would like to implement a SIMS. I know of 3 open-source SIMS: Prelude, OSSIM and OpenSIMS. Is one better than the other with my mixed environment? 5- Would a Change Management Solution like Radmind on top of all that be compatible worthwile, or it would mainly be redundant ? So my question again: does anyone here know the best way to implement all of these (Integrity Checks, Servers Monitoring and remote Logging) in a mixed environment (UNIX/Windows), everything being open-source ? Thank you. ...

sendmail still logs old hostname in /var/log/mail.log
after changing the host name and restarting rsyslog information in mail.log still shows the old host name. Linux newhostname 2.6.38-8-server #42-Ubuntu SMP Mon Apr 11 03:49:04 UTC 2011 x86_64 x86_64 x86_64 GNU/Linux ?? never mind........it started working........ musta been just enough time for the FQDN to implement -h "horus" <horus@sonic.net> wrote in message news:4ea13b8e$0$1641$742ec2ed@news.sonic.net... > after changing the host name and restarting rsyslog > information in mail.log still shows the old host name. > Linux newhostname 2.6.38-8-server #42-Ubu...

Why does: "tail -f /var/log/messages | grep eth0 >> /var/log/eth0.log" create an empty log ?
bash scripting question: if: "cat /var/log/messages" yeilds: it87-isa-0290 Adapter: ISA adapter Algorithm: ISA algorithm VCore 1: +1.79 V (min = +1.48 V, max = +2.01 V) VCore 2: +1.24 V (min = +1.02 V, max = +1.37 V) +3.3V: +3.21 V (min = +2.80 V, max = +3.79 V) +5V: +4.97 V (min = +4.23 V, max = +5.75 V) +12V: +12.00 V (min = +10.16 V, max = +13.80 V) Stdby: +4.80 V (min = +4.23 V, max = +5.75 V) VBat: +0.00 V fan1: 5578 RPM (min = 3000 RPM, div = 2) fan2: 2922 RPM (min = 0 RPM, div = 2) M/B Temp: +43�C (l...

Log Log square plot
Hi, I'd like to plot a distribution on a log- log^2 graph. Those graph look like gaussian graph but with the x axis on a log^2 scale and y axis on log scale. They are call Cole chart and are use for ploting cumulative particle size distribution. Can someone help me. Thanks Jean-Mathieu Gagnon Johnnyhat <jeanmat66@hotmail.Nospamm.com> wrote in message news:<eed95f9.-1@webx.raydaftYaTP>... > Hi, > > I'd like to plot a distribution on a log- log^2 graph. Those graph > look like gaussian graph but with the x axis on a log^2 scale and y > axis on log scale. T...

Can LOG PI or Log Explorer recover deleted records BEFORE
installation of their softwares? If there has NEVER been a backup of the Database (.mdf), Recovery Model Set to Full, and there has never been a backup of the Log (.ldf) files? Using the trial software for both, this was unclear. Thank you for your time, bd "bd420" <bd420@hotmail.com> wrote in message news:1136940831.527840.99440@o13g2000cwo.googlegroups.com... > installation of their softwares? If there has NEVER been a backup of > the Database (.mdf), Recovery Model Set to Full, and there has never > been a backup of the Log (.ldf) files? My understanding is...

Archive logs files accumulating on my Oracle log mode Database
>From what I understand is that an Oracle log mode Database is the recommended configuration for a production database. However, the problem we have is that Archive Logs files in the ..\RDBMS\ directory are accumulating daily which has implications when you have limited disk space. How should these Archive log files be maintained? ie when should they be deleted from the system? is there an automated procedure which will remove the log files on a weekly basis? I understand that there are two ways for performing a backup of the oracle database, 1) cold backup (requires the oracle database to be shutdown) 2) hot backup Should either of the above backup procedures automatically remove the archive log files once backup has been completed? Thanks in advance. James Osso wrote: >>From what I understand is that an Oracle log mode Database is the > recommended configuration for a production database. However, the Not for all production systems... Data ware houses usually are easier rebuilt than restored. Of course, apply common sense and *your* requirements. > problem we have is that Archive Logs files in the ..\RDBMS\ directory You can configure that - pfile, or spfile - depending on version. > are accumulating daily which has implications when you have limited > disk space. > > How should these Archive log files be maintained? ie when should they > be deleted from the system? is there an automated procedure which will > remove the log file...

Oracle database instance shutdown without logging in log file
oracle database instance shutdown without logging in log file. we have Oracle 10g(10.2.0.1)(HP DL380) databse server from Windows 2003 R2 for test/simulation purpose, we found that its shutting down the database sometimes unusally without any error/warning message in the SID alert log file. we observerd that the OS service for oracle is not starting the datbase server completely. Just after hitting start icon inside the services panel it displays the status "Starting", instead of "Started" and database is not in the "Open" state. So the method adopted to start the database from services as well using the "Startup" command from server manager utility. Why does this happen? On Apr 17, 12:19 pm, 7guru <7...@naver.com> wrote: > oracle database instance shutdown without logging in log file. > > we have Oracle 10g(10.2.0.1)(HP DL380) databse server from Windows > 2003 R2 for test/simulation purpose, > we found that its shutting down the database sometimes unusally > without any error/warning message in the SID alert log file. > > we observerd that the OS service for oracle is not starting the > datbase server completely. > Just after hitting start icon inside the services panel it displays > the status "Starting", instead of "Started" > and database is not in the "Open" state. > > So the method adopted to start the database from services as well > using t...

Logging vs. Exceptions
Hi all I am moving a rather big Perl application to Ruby, due to the nasty way Perl (un)handles exceptions we originally used log4perl (a log4j/log4r like logging facility) heavily in a 'log and recover' like manner. Ruby however have a quite nice exception semantics and thus I am playing with using exceptions where I used to use logging. This brings us to the dilemma of when to throw errors and when to log them. I read on the net that a good policy is to either 'catch, wrap and throw', or 'log and recover', but never neither nor both. Although this sounds like a re...

Log
Hello all, I have a program that creates a log file if some conditions are met... I want this log file to be sent to my email address... how can I achieve that? Thank you in advance... "none" <teddyjawilliam@gmail.com> wrote in message news:1164796331.488414.313960@j44g2000cwa.googlegroups.com... > Hello all, > I have a program that creates a log file if some conditions are met... > I want this log file to be sent to my email address... how can I > achieve that? > Thank you in advance... > You can use a day/time trigger (perhaps by default or command lin ...

log
hello,is it possible to record on solaris machine, logdata like pf log BSD, from a remote machine? if yes howto? thanks papy74 Hi, papy74 wrote: > hello,is it possible to record on solaris machine, logdata like pf log > BSD, from a remote machine? if yes howto? > thanks > papy74 Asking about a specific BSD (which flavour and with which additional software?) logfile is pretty pointless. A quick search shows a potential translation to something like "how to log accepted/denied ip connections to a remote machine?". If this is the intend of the query, then IP Filter i...

Why does Error log show database restarting everytime a transaction log backup runs?
Why does Error log show database restarting everytime a transaction log backup runs? It also runs a checkdb as well. The log backups are scheduled through a maintenance plan. Is this normal? Sanctus (mchi55@hotmail.com) writes: > Why does Error log show database restarting everytime a transaction > log backup runs? > It also runs a checkdb as well. > > The log backups are scheduled through a maintenance plan. > > Is this normal? Sounds like the maintenance plan includes a CHECKDB that sort of thing as well. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx ...

SAS log to output and to log window
Hi, I am using SAS 9.2 on Windows (not the Enterprise Guide) and would like to have the following feature: I want to save the log output to a text file, while also showing it in the log screen of the SAS application. Redirecting the log file works fine with proc printto, but then the log windows remains empty. Is there a trick to do this? Thanks Dornak Yes, when your session is done, do a "Save as" while selecting the LOG window. "Dornak" wrote in message news:f1654b61-2021-413d-a2bd-ff96625b9b83@3g2000vbx.googlegroups.com... Hi, I am using SA...

linear regression on log log plots
Hello, I have two variables (vectors): L=[0 200 400 600 800 1000] %L:Length S=[0.002 0.001 0.003 0.001 0.002 0.01] %S:Slope and I have to calculate the coefficients Lambda(slope) and Gama(intercept) of a straight line by regression of my data on log-log graph. formula: lnS=Gama-Lambda*lnL; In cftool, axes are normal (not log-log). I also tried ployfit(x,y,n) in polyfit(log(L),log(S),1) way, but it didn't work and answer was NaN NaN. what code should i use for fitting a straight line(linear fitting) and calculation of Lambda and Gama. thaks in advance It does not work because L(1) = 0, so log(L(1)) = -Inf, and polyfit can't fit a line with an Inf point. Try: polyfit(log(L(2:end)),log(S(2:end)),1) and it will work. F "Alireza Y." <bilgi_yk2@yahoo.com> wrote in message <hf5ab1$qs8$1@fred.mathworks.com>... > Hello, > I have two variables (vectors): > L=[0 200 400 600 800 1000] %L:Length > S=[0.002 0.001 0.003 0.001 0.002 0.01] %S:Slope > and I have to calculate the coefficients Lambda(slope) and Gama(intercept) of a straight line by regression of my data on log-log graph. > formula: lnS=Gama-Lambda*lnL; > In cftool, axes are normal (not log-log). I also tried ployfit(x,y,n) in polyfit(log(L),log(S),1) way, but it didn't work and answer was NaN NaN. > what code should i use for fitting a straight line(linear fitting) and calculation of Lambda and Gama. > thaks in advance On Wed, 2 Dec 2009 09:00:17 +0000 (UTC), &...

Web resources about - Log Explorer vs. ApexSQL Log vs. SQL Log-Rescue - comp.databases.ms-sqlserver

Resources last updated: 3/22/2016 3:57:18 AM