Third-party Log Analysis Tools?

Mar 7, 2008



We're looking for a sql server log analysis tool. Currently we often need to identify which users execued DML in the database. But I can see other uses for a product from this tool category. I'm looking at APEXSQL Log and Lumigent Log Explorer.

Can anyone make recommendations for other tools?


Thanks,
Tom

View 4 Replies


ADVERTISEMENT

Backup Strategy - SQL2005 Tools Versus 3rd Party Tools

Jun 1, 2007

I am running SQL Server 2005 x64 Enterprise under Windows 2003 x64 Enterprise. My current backup strategy uses T-SQL jobs run by SQL Agent (writes out *.bak files) and then I have an Integration Services job that copies the *.bak files to our NAS device. I have performed a restore without issue. The jobs are all automated every four hours via SQL Agent. Is this a sound strategy or are there additional benefits to using 3rd party tools? If so, what are the advantages and which tool provides them?

View 3 Replies View Related

Third-party Tools For DBA

Apr 27, 2008

hello,

what are some good db managements tools that are available? I installed Toad from Quest and the Red Gate's toolbelt but I haven't play with them yet. I would like to know what is the most useful tool to invest time in.

Thanks.

View 1 Replies View Related

3rd Party Monitoring Tools

Apr 11, 2002

I have been using the built-in tools of SQL Server (email and netsend) to monitor and alert me about some basic issues (like severity errors and job failures) with our SQL servers. We are now approaching a level and number of servers where I think we need to get a more global and more stable solution to monitoring and alerting.

So what third party tools are you are using to monitor your SQL Servers?

Thanks

SJ
shawn.johnson@kenexa.com

View 2 Replies View Related

Third Party Tools That Add Sp Debugging

Oct 30, 2007

The only way I know of to debug a Sql 2005 stored proc is to create a VS2005 Database Project and step into it from there. Does anyone know of any third party tools that adds functionality to Sql Management Studio to step into stored procs?

View 5 Replies View Related

3rd Party Tools For Job Scheduling

Jul 20, 2005

I am looking for a better way to schedule jobs in SQL Server. I foundthis tool called SQLschedule at www.idera.com and am using the 30 daytrial. This tool really has a cool GUI, and seems to work well. Doesanyone else have any experience with their tools?

View 1 Replies View Related

Analysis :: Create Analysis Services Project In Visual Studio 2012 Data Tools?

Feb 18, 2013

It is possible to create Analysis Services project (*.dwproj) in Visual Studio 2012 Data Tools?

View 5 Replies View Related

RE:Third Party Audit Log Analysis Product.

May 20, 2000

Hi guys,

Does anyone knows of any third party product that does audit log analysis in SQL server.


Thanks in advance

kenny
dba

View 1 Replies View Related

Tools For Analysis Relations

Feb 27, 2006

Are there tools for SQL2k database that take a database return allrelations of tables.thanks.Stefano.

View 4 Replies View Related

Data Load Analysis Tools

Apr 4, 2008



In the process of building a data warehouse is their an easy to test if the data received is right data.
Are there any tools free tools available

Or do i have to build these ssis packages
Please let me know

View 1 Replies View Related

Analysis :: Where Are Tools To Allow To Connect To Server And Work With Tabular Models

Jun 10, 2015

I see we can install SQL Server 2016 CTP2 and Tabular SSAS.However, where are the tools to allow us to connect to the server and work with the tabular models?Supporting features such as bi directional filtering, etc..The existing SSDT BI tools for 2014 don't contain those additional features (editing relationship filtering direction for example).

View 2 Replies View Related

Analysis :: OLAP Cube Data Visualization Tools For Desktop?

Jun 5, 2015

I am looking for some Simple/Best Data Visualization tools for Desktop which accept data from SSAS Cubes.

View 5 Replies View Related

Errors In Table Analysis Tools For Excel DataMining AddIn

Mar 2, 2007

It's an error "The 'MINIMUM_DEPENDENCY_PROBABILITY' data mining parameter is not valid..." always I try to run Analyze Key Influencers Tool. How it's possible to fix it?

View 5 Replies View Related

Licensing Of Data Mining Tools With SQL 2005 Analysis Services

Oct 25, 2006

A rather dumb question but I've installed an evaluation copy of SQL 2005 on my machine and a colleague would like the Analysis Services Data Mining capability on his machine (without the eval SQL Server).

Is there a license associated with such an installation when we buy 2005 or does it fall under client components which can be installed on any number of users machines?

Matt

View 1 Replies View Related

SQL Tools :: How To Disable Customer Improvement Program From Menu For Server MGMT Tools 2012

Mar 25, 2014

Am customizing SQL server MGMT tools 2012 for Mass deployment.Client had asked to remove Customer Feedback option from help menu.how to disable that.

View 6 Replies View Related

SQL Tools :: R2 Management Tools Install Fails - Specified Account Already Exists

Oct 20, 2014

The installation SQL 2008 R2 Management Tools on a Windows 7 workstation fails with the error, The specified account already exists.

Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.

  Exit code (Decimal):           -2068052700
  Exit facility code:            1212
  Exit error code:               1316
 
[code]...

View 10 Replies View Related

Design Tools / Sql Server Mgt Tools Cause Login Fail

Sep 20, 2007

Login failed for user 'TOSHIBA-USERASPNET'
I know that the file persmission for the web application have to include aspnet, so i keep resetting the folder permission for aspnet in file manager, but the login failed keeps coming back every day or two
problem is after working with VS05 Pro, SQL Server Management Studio CTP, somehow the aspnet persmission get changed, use alot of sqldatasource wizards and often there is a conflict/hang between the datasource wizard and the need to have the mdf in a dettached state within VS server explorer,
not sure but the procedure to fix this seems to be to reboot, detach and re-attach the mdf in the Sql server Studio tool, re-apply the aspnet file permission on the web app folders (wonder should i be doing this in IIS instead), make sure the mdf within server explorer is detached, the it works
anyway, getting real tired of the resulting delays and design time derailment, clues greatly appreciated, thanks
 sometimes i can use View in Browser when in VS05 form view and i wont get the aspnet folder permission error and other times i do.
last thing, is it a bad idea to give aspnet full permission for the entire web applicaiton??
 

View 2 Replies View Related

SQL Tools :: Tools To Determine Version From BAK File

Apr 24, 2014

Is there - apart from the notorious RESTORE HEADERONLY - an tool which is able to tell which SQL Server version created a specific BAK file? I'm looking for a tool that can be used w/o an available/running SQL Server installation.

Alternatively, is there any documentation about what is read with RESTORE HEADERONLY so I could write a tool myself?

Where would I find the version "bytes" in a BAK file?

View 4 Replies View Related

Server Tools Or Client Tools?

Jun 16, 2008

Dear All,
how can we know that wether we had server tools or client tools on my machine?

Arnav
Even you learn 1%, Learn it with 100% confidence.

View 1 Replies View Related

Tools Tools Tools For Performance ???

May 16, 2002

Know any good performance monitoring and analysis tools for SQL server.

View 1 Replies View Related

Third Party Tool

May 1, 2001

Hi All,

I have to load data from from a text file ( approx 3-5 million rows) into a table .

I can use straight bcp with the format file , but the loading of data has to follow some business logic

Let me know if there are any third party tool to load the data instead of regular bcp

I have SqlServer 7.0 on Windows NT 4.0

Thanks in advance

View 2 Replies View Related

3rd Party Software

Oct 13, 2005

Does anyone know any software to backup single tables ? i recall one software that extracts the data into a text file called SQLinsert or something but wondering if they are others around ?

View 1 Replies View Related

Third Party Software

Sep 12, 2007

Hey guys I really need your help.

We've outsourced our software last year, and it really a big mess for us since that company has been clashed. Then it so happened that the system failed to function well. Our batch transactions was working about 56 mins.. that is 24 records. Then it happened that this time 28 records was finished for about an hour. Our business hour is 8 hours only. That's why we have a back log now. We also failed to validate transaction since it takes a lot of effort before we update the database. It's working before but as our database becomes larger there are many errors occur in our application. Majority is runtime error. Then it happened that now we cannot move on anymore. We are using SQL server 2000 with VB6.0 application. our server memory is 1GB. Do you think adding additional memory will solve our problem?

Thanks!!

View 1 Replies View Related

Third Party Sql Tool

Jul 20, 2005

I prefer to write SQL code, without graphical tools.Have third party Query Analyzer that has filter and sort abilities?Also I looking for SQL editor with Completion ability (like we know forprogramming lang),for assist me write more quickly.

View 1 Replies View Related

Using Third Party ADO .net In Script

Oct 24, 2006

I am working on a SSIS package to move data between SQL2005 and DB2. I currently have the DB2 ADO .Net connector from DataDirect which works fine for connecting to the AS400. My question is that I am working on a script transformation and I want to be able to use the Connection already created in the package their.

I can set it up just fine using the properties for the script, but there appears to be no way to create SQLCommands and connections unless I reference the DataDirector DLL in the script, which requires adding it to the GAC and the Framework folder.

I am just wondering if this is the correct way to go about this or if there are any other recommendations. Please let me know if I need to supply more information.



Thanks,
Chris

View 1 Replies View Related

Third Party Backup Programs

Feb 27, 2002

Currently we are using SQL Servers Backup utility to backup our databases to disk and then the files to backup tape during a nightly backup.
The time it takes for the backups to disk to complete for the databases is becoming prohibitively long and performance problems on the DB server are manifesting.
I am interested in other solutions. However, the propaganda listed at the various companies sites are less than insightful.
I was wondering if anyone used a third party Agent like Brightstor Enterprise SQL Server backup agent, or Veritas NetBackup for SQL Server, that would be willing to give some recommendations. If you use something that isn't listed here and it works well, I would be interested in hearing about it.
Do these backup agents significantly slow down the database performance? Do they create any locking issues? Some insight into your backup hardware configuration would be helpful as well. Thanks in advance for your help.

View 1 Replies View Related

3rd Party Search Engine Web To SQL?

Sep 6, 2005

Hi All,
I am pretty new to SQL and would like a bit of friendly help, please. Am trying to set up a .Net web site that will have dynamic content supplied by a true SQL server (am using MSDE to build this first).

My issue is in building a search engine on my web site that will return hits from the content of the pages which are loaded in MSDE.

Is there a third party or open source search engine available?

Any clues for how to build (or beg, borrow or steal) a workable search engine to do this?

Many thanks,
Newbie

View 4 Replies View Related

Third Party Reindexing Utilities

Jul 23, 2005

Folks,I work on a system which is growing rapidly, with the number oftransactions we process growing on a daily basis. While this is goodnews or the business, maintenance is starting to become an issue as thedatabase is the backend for a website which cannot be down for alengthy period of time.While I do defrag the indexes, periodically the indexes do need to berebuilt. When this happens, the process locks pages and transactionsstart getting bounced out.Are their any third party utilities which will rebuild an indexwithout this locking occuring? Any help in pointing me in the rightdirection would be appreciated.

View 1 Replies View Related

Third Party .NET Charting Packages

Mar 19, 2007

Can SSRS be configured to use any third party .NET charting components or only ones that have been specifically designed for SSRS? I have seen a couple of third party charting software (Dundas, etc.) and while they are nice, they sell at a real premium and there are not many vendors offering SSRS charting. I was hoping for a bit better value and more of a selection to choose from.

R

View 4 Replies View Related

Third Party Supplier Access To SQL

Apr 24, 2008



We have a hosted SQL server with various internal applications on it. It has been decided by on high that the same server will also have a database from a third party on the server. The third party have asked for full system admin rights on the SQL server.

Obviously I am not going to grant that access level as it gives them full control on the box. From my viewpoint read and write access to the data can be tolerated but anything else will be denied. Would you consider this standard and is there any documentation with recommendations for control of external suppliers ?

I am sure that they shouldn`t be doing any work on tables structure, sp`s etc on a live database. That work should be tested, scripted etc and then run on in a controlled environment by my company.

Anyone have any advice ?

Thanks

SI

View 1 Replies View Related

Help Reading From 3 Party Source

Apr 9, 2008

Hi,

I have a commercial data source 3 party one for me to extract data from , i have been provided the exe and the DLL how i can use this in SSIS as a datasource please let me know.

Thanks,

View 4 Replies View Related

Third Party Components For SSIS?

Oct 10, 2007

hello all -- I'm an SSIS newbie who is exploring (custom) programming functionality through third party components, to be plugged into SSIS, for SMTP, FTP, PGP, TAR, WinZIP, basically for a scheduling & automation utility.

Is there such a concept of third party components (and marketplace for this?) or is VB a much better choice for this vis-a-vis components variety, $$ and robustness ?

thanks much,
Cos

View 1 Replies View Related

Modifying With 3rd Party Application?

Oct 30, 2006

Hi,
I have recently started using SQL Server with a 3rd party application and have come across a problem and i have no idea how to fix it...

The database has a column of numbers that go up either by 10 or 100 depending on the letter in another column. eg:

100 M
110 P
120 P
200 M
300 M
400 M
500 M
510 P
520 P

The 3rd party application has just been updated and now can add new rows to this table. The only problem is that the added row needs a new number, and the rows below need to be recalculated.

Is there anyway this can be done? Any help or suggestions would be great!

Cheers,
BL

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved