Tell Me Some Third Parts Monitoring Tools
Mar 15, 2002Hi, gurus:
Please tell me some third parts monitoring tools for MS SQL server 2000.
ADVERTISEMENT
Monitoring Tools
Dec 22, 2004Hi all,
I'm looking into the possibility of buying (as I doubt there's any good free options) a SQL Server Monitoring tool.
Has anyone got any particular recommendations - good or bad? I know a little about Spotlight, but not much else.
Thanks in advance.
---------------
zinedunc
Monitoring Tools
Mar 7, 2007Hi,
We are evaluating proactive monitoring tools for our heterogeneous database environment, currently comprising of Sybase and MS SQL Server.
Our current options are Bradmark Surveillance, Quest Foglight/Spotlight, MOM (SQL Server only) & Embarcadero Performance Center.
Are there any recommended tools from your experience? Or any tools with with you have had bad experience?
Tia.
Monitoring Tools.
Jul 20, 2005All, I seek your knowldege. I am looking for a monitoring tool thathas the abilility to page and email me should something go wrong withSQL server. I know of two such tools: 1.) BMC Patrol, and 2.) Quest'sFoglight. I was hoping that some of you have had some experience withother such tools. Let me know please.Louis
View 1 Replies View RelatedServer Monitoring Tools
Jun 14, 2000I want to know if there are any tools that will allow
a DBA to monitor changes that occur on SQL databases
(deletion, addittion or modifications) on any objects,
and Sql security.
I have looked at Profiler in SQL and it is very limited
and plus it is huge memory hog and causes degradation on
your servers.
MS SQL Server Monitoring Tools
Feb 19, 2004We've got about fifty MSSQL Servers (7.0 and 2000) in our shop.
Can anybody recommend a good tool to monitor all kind of activities and conditions on those servers?
3rd Party Monitoring Tools
Apr 11, 2002I 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
Tracking Changes And Monitoring Tools
Aug 19, 2007I want to integrate my Production SQL boxes to Visual Source safe.
Can you please guide me on this also if there is any Alternative to
track the chnages in the stored Procs?
How is SQL SPOT LIGHT from Quest as a monitoring tools?.
Or
Can you please suggest me any other tools which are good for monitoring SQL Servers.
Thx
Venu
Performance Monitoring Tools For SQL Server
Aug 29, 2001Hi,
I'm looking for tool that will help me to monitor and analyze SQL server performance including SQL activities and server activities(cpu, memory usage) as well.
I appriciate any feedback,
Thank you,
Yelena
Favorite Monitoring (Performance) Tools?
Apr 25, 2007I'm fairly new to the DBA thing.
I've been doing quite a bit of research on monitoring MSSQL performance.
What tools are you guys using?
PerfMon, Dbartisan, Spotlight, or what?
I'd like to find some free or affordable way to watch our Servers to check health/performance/etc.
Tools For Monitoring Sql Database Access
Feb 2, 2008is there a tool or vb.net code for monitoring who is accessing my sql 2005 express databases? username, computer name, etc.?
View 5 Replies View RelatedDatabase Change Management Tools - Monitoring Changes?
Jun 25, 2012Have audit requirements that require that all schema changes to certain database are tracked and monitored. Any tools that can monitor these changes and log them for audit review?
View 3 Replies View RelatedSQL 2012 :: Monitoring Tool Using Powershell And Performance Monitoring
Sep 15, 2014We are in plan to build a Monitoring tool using PowerShell and Performance Monitor which could monitor 10 to 20 servers. Do you have any reference of any existing tool using Performance Monitor to monitor the SQL Server and available for free? I didn't want to put some effort, if something is available already.
View 2 Replies View RelatedSQL Tools :: How To Disable Customer Improvement Program From Menu For Server MGMT Tools 2012
Mar 25, 2014Am 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 RelatedSQL Tools :: R2 Management Tools Install Fails - Specified Account Already Exists
Oct 20, 2014The 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]...
Backup Strategy - SQL2005 Tools Versus 3rd Party Tools
Jun 1, 2007I 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?
Design Tools / Sql Server Mgt Tools Cause Login Fail
Sep 20, 2007Login 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??
SQL Tools :: Tools To Determine Version From BAK File
Apr 24, 2014Is 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?
Web Parts Without Personalization
Aug 17, 2007i am using web parts with drag and drop feature , i did not use aspnetdb for user membership
while it is published it gives eror as follows
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. SQLExpress database file auto-creation error:
The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:
If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist.
If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database.
Sql Server Express must be installed on the machine.
The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts.
Please give me ur valuable advice , thanks in advance
What's The Best Way To Dupe Certain Parts Of My RS?
May 29, 2002Hi!
Mgmt just decided that the designer (me) was more valuable than the developer (now me). I hope there are some gurus out there who can help.
What would be the best way to duplicate certain parts of my RS? Suppose
I have a table with three columns: ID, adName, and priority. When I serve the ads, I am randomizing them, but would like to serve some more frequently than others. I am hoping there is a single query I can use, that will seed the RS with multiple instances of high-priority records.
Should I stick to play-doh?
Date Parts In SQL V6.5
Mar 10, 2003I am still using SQLv 6.5 and have a need to do monthly reports. It is my understanding that there is no inherent capability in SQL v6.5 for functions such as MONTH getdate() as exist in SQL 2000. Does anyone know of a script that will simulate this so I can extract information from a database such as date_last_update IN MONTH 02?
Thanks
Dale
SQL Pieces-parts
Jul 20, 2005I'm very familiar with Oracle at a conceptual level and need tounderstand MSSQL as well. Can anyone point me to a document/web pagethat describes the different files used in MSSQL and a discussion of howthey relate? (ex. with Oracle, there is tempdb, redo, archive, db files,rollback, etc.)
View 4 Replies View RelatedGetting Parts Of DateTime Field
Jun 8, 2008Hi everyone,
I want to get year, month, day and time parts of a DateTime field in sql,
Can help me?
Splitting Dataset In 2 Parts
Mar 22, 2012I have 5 records in a table called "testing" as such:
LetterCdcontact_id
x1
x2
x3
x4
x5
How can I split this dataset so that three records have LetterCd = 'y' and the other 2 records have LetterCd = 'x'? The number of records can vary, but the idea is the same: split the values in the LetterCd column evenly (50% = 'x', 50% = 'y'). LetterCd is varchar(25) and contact_id is int. I can't update the data, it would have to be a SELECT statement with some sort of CASE statement to get the remainder of the record count?
Deleting Parts Of A String
Mar 18, 2014The issue is that I need to delete parts of this string using SQL Server.This string is a title of a document which should contain only the Document Category & Title. Instead, it is displaying extra parts such as Year, Date Created, etc. I would like to truncate/parse off the title. The database is Acme_system. The name of the table is dbo.documents, the column name for the title is "title" and there is also column is "childcat".
The title string reads:
2013-730-DAILY NOTES AND TRACKING FORM-11-16-13 700-030714
I want to take off everything except for "DAILY NOTES AND TRACKING FORM-11-16-13 700"
Select Parts Of Information
Apr 20, 2008Hey guys,
I was wondering if this is possible I have to be able to just select the number before the '-' in acolumn which is formatted like 123-456 so I just need the the 123 part.
Any ideas how this can be achieved?
Thanks.
Deleting Parts Of String
Mar 18, 2014The issue is that I need to delete parts of this string using SQL Server.
This string is a title of a document which should contain only the Document Category & Title. Instead, it is displaying extra parts such as Year, Date Created, etc. I would like to truncate/parse off the title. The database is Acme_system. The name of the table is dbo.documents, the column name for the title is "title" and there is also column is "childcat".
The title string reads:
2013-730-DAILY NOTES AND TRACKING FORM-11-16-13 700-030714
I want to take off everything except for "DAILY NOTES AND TRACKING FORM-11-16-13 700"
Selecting Parts Of Data
Apr 20, 2008Hey guys,
I was wondering if this is possible I have to be able to just select the number before the '-' in acolumn which is formatted like 123-456 so I just need the the 123 part.
Any ideas how this can be achieved?
Thanks.
RS Web Parts On SharePoint 2007
Feb 20, 2007Hi,
I'm having troubles connecting the webparts on SharePoint 2007. I installed the RSWebParts package from SQL Server 2005 Reporting Services on my MOSS 2007 box. The installation went smoothly and I can add both Report Explorer and Report Viewer on a page. But when I try to connect RE to RV I get the following error:
An unexpected error has occurred.
Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.
So I have to go to the maintenance page and remove the web parts.
Have anyone managed to bypass this and make them work together?
Thanks,
Sending Parts Of The Report
Feb 22, 2008
Hi,
I prepared a report including sale information of a company. There are different offices of the company in different locations. And in each offices there are more than 1 saleman. I have to send the report (but just the associated part of the report to the saleman, not the whole one) to each saleman and his/her manager. I prepared a subscriber data (name and mail addy) for each office. How can i send the associated part of the report to the salemen and his/her manager by using just the original report (I dont wanna seperate the report depending on the saleman and send each report one by one, cuz there are many offices and salemen)
Thank you
Secure Parts Of A Table
Sep 30, 2007This is the thread
http://msdn2.microsoft.com/en-us/library/ms998292.aspx
Here it mentions the following
Deployment Considerations
When using Windows authentication to connect to SQL Server in production
environments, consider the following:
Use a custom service account.
Create a SQL Server login for a Windows group.
Assign database permissions to a database role.
Use a Custom Service Account
This is my problem we are trying to convert all our web pages to use Windows Authenication.
DOMAINWEBGROUP (for example).
Tracey and Jack part of this group
But sometimes there may be anothers added to this say John
The security comes from SQL right now i give data reader to the database.
Example
1. ASP.NET uses the service account DOMAINWEBGROUP
2. Assign WEBGROUP to database PERSONEL
Table Employees
Salary
Web Page
Lets say Tracey logs into the web page.....and i have two pages
1. Employess
2. Salary
As the WEBGROUP is data reader viola Tracey sees all salary information.
Im trying to figure out that only Tracey can see Employees
But im not seeing the relationship when using WEBGROUP
Is there a way in SQL to say yes we have the DOMAINWEBGROUP
but in sql also put in Tracey and know that Tracey is part of DOMAINWEBGROUP
So that in my tables i can only give tracey part of this employee table (say the first name last name) and not salary information. (I know how to use the roles).
The part im confused about is the mapping WEBGROUP to tracey in sql as the web developers only pass in WEBGROUP
Can I Cause Parts Of The Report To NOT Print?
Apr 30, 2008
I want to add some information to a report that I do NOT want to be included in the printed output. Is there any way to designate a rectangle or list or table to NOT print?
Thanks.
Server Tools Or Client Tools?
Jun 16, 2008Dear 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.