Which One Of These SQL Monitoring Tool Is The Best?? Please Advise..!
Jul 23, 2005
I am in the process of evaluating some SQL Performance Monitoring /DBA
tool to purchase (For SQL Server 2000). I have the following list of
software that I came across and have to finalize which one to recomend
for purchase by my company.
Quest Central® for SQL Server
Performance Center by Embarcadero (dbartisan)
Performance analysis by BMC Software solutions
SQL Server Management by netIQ
I would greatly appreciate if anyone can give me a comparison/ any
suggestions on the above mentioned applications...!
Has anyone used/currently using any of these applications? Please
advise...
We 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.
I am new to the db world so please let me know if I don't make any since.
I was wondering if there is an open source SQL database monitoring tool out there that I can run on my desktop that would give me a log of what is going on on the database (or the server).
I have built a website using asp.net 2005 that uses sql server 2005 database, my question is, which tool can I use to monitor the connections to the database, because I feel that some of them are left open for a very long time.
Our shop is expanding use of SQL Server, both 2000 and 2005. We haveLitespeed on some boxes to handle the backup/recovery jobs. Can I askwhat are considered the best tools for monitoring SQL Server, in termsof things like performance monitoring, tuning and auditing if it ispossible to get all of this functionality in one?What do you use and like?Thanks in advance.Gerry
hi guyz i want to integrate Sql Server 2000 with Microsoft Monitoring tool , and wht I exactly want is , I need a report of each users and their internet history. i have an application on asp.net 1.1 in which i need to import data from some source it may be microsoft proxy server or any monitoring tool. 1 of my mate suggested me to use the tool which lies at : Control Panel -> Ad Remove programs -> Ad Remove windows components -> managment and monitoring tool -> Monitoring he was not sure either this tool can be integrate with sql server or not. but i need some data in to my tables, can any1 help me in this regard kindly ask me if there is any confusion u guyz can email me as well ..... do let me know if know 1 find any solution thnx
SQL Stripes is an application that helps you, the SQL Server DBA, having complete control over your various SQL servers. From the high-level of monitoring essential components - to the low-level of analyzing your various databases, tables etc… This is *not* another Query-Analyzer like tool, nor does it intend to be. The idea is that each one of your servers gets a 'Stripe' which contains valuable real-time data on the selected server. SQL Stripes is an intuitive and easy to use application, which is intended to make your DBA life a bit easier.
SQL Stripes is completely free. Please send your feedback/questions/suggestions
helloI have two related tabletable1cIdcDesctable2IdNamephonecIdThese two tables are relatedwhere cId in table 1 is primary key and cId in table2 is foreign keyIf I want to delete a record in table 1 which is related to table 2Which is faster and more accurateshould I write my stored procedure like thisif exists(select * from table2 where cID = @CID)delete from table1 where cID = @CIDelsereturn 0------------------------------------------or------------------------------------------delete from table1 where cID = @CIDif @@error<>0return 0
I just want to ask one question and i am looking for advice or recommendation.
I want to make an application using windows application in .NET. this application is only to have one or two users to enter details of clients on the database using the application and it will be a search for client name or number and other search methods which is similar.
My question now, what database shall i use for this kind of application SQL server or MS Access. i am looking for a new product to use as the cleint can not afford expensive software. Please advise!! thanks!!
Version: SQL Server 7.0App: MS Access 2000I created DTS to move records from MySQL to SQL Server (approx over 500,000+per months dataset) for purpose of canned and adhoc reporting. The apphave a simple interface using MS Access where user will input the timeframeof the dataset they will process.Both servers are physically located in the same bldg from another state.Previous to MySQL, they send us cd in text format and my app runs the DTSusing a BAT file containing the DTSRUN command. But I would like stay awayfrom the DTSRUN since they take awhile to load to the server, plus it runson background on client pc. I wanted a functionality where it will run onthe server without user supervision, and they can go about their businessand do something else. In other words, let the server do majority of thework.Now that MySQL came into the picture, the Network Support created a filedsnwhere sqlserver sits and I use that as a reference on my DTS (using UNC,\myserverfile$sample.dsn)The problem:1) I work from home and when creating and running this DTS's, it takes awhile to process;2) When specifying the UNC path on DTS and saved, for some reason itswitches to the User/System DSN section;3) I also tested from office with the same result (i connect using cablemodem)Now the only way I can think of to solve this problem:a) save the DTS as a file and send it over to Network Support and have themload it up and manually change the source location OR have them modify theDTS and change the source locationb) then create a DTS jobThe person who will be running this DTS might be running it from home oroffice. Also, is there a way to automate the DTS job using an SP? I wantedto make it as easier as possible for the end user, where all they have to dois enable the job and run only for this time and for this package.TIA!Bob
on the 1st opening of my web page it uses the membership control of asp.net for logging on. sometimes it takes time to logon and worse is, it will encounter sql server error. that can be resolved by just restarting that specific page and it will be alright, it will logon normally. this only issue happens only on the first opening of the logon page. i have read a certain article and it says there that on the first time you access the sql server, sometimes the sql server needs a little more time communicating back and forth. how can i make my log-on page wait a little longer till it communicates or finishes communicating to the sql server? im afraid that this may happen once i deploy my web project. i am expecting over 100 users and they might save to the database all together. will i encounter problem on this particular? i am using ASP.NET 2.0 and SQLExpress for this project. pls advise me. BIG THANKS.
I have been given a DB that currently stores Organizations. I need to add the ability to track multiple contacts for the Organizations. The DB has several one-to-many relationships on the Organizations table, such as Documents and Notes. I would like to track these by contact as well as the organization. Is it possible to add a tblcontact and a one-to-many relationships to the Organizations table as well as to the tblDocuments and tblNotes? I appreciate any suggestions. tblOrg (OrgID) tblDocuments (DocID, OrgID) tblNotes (NoteID, OrgID) tblContact ???
I would be appreciate to hear some advice regarding my mission to upgrade from SQL Server 6.5 to 7.0. The database would still be located in the same server. Do I have to do checking on the datatypes? - many thanks-
I have been working with Ms access Database the last four years and have gained a lot of experience which help me to have extensive knowledge of Jet, Dao and Ado. Since The Begining of this year i hv been migrating to SQL server server and for that i bought two books :Programming Access project file with Microsoft Sql server and Access Developers Guide to Ms sql server : Chipman & Baron ( this oner is simply a great achievement ). They help me out in the very near past to complety migrate a two database approch Jet Application to a reliable (Adp/ SQL Server client server ) where major parts of the code business logic has been transfered to run on the server as stored procedures and all forms re-built as unbound. these merely leads to a great enhancement of the applications.
My goal now is register to MCDBA and get the certification. I am not interested by classroom training from Microsoft Parterns or online training. I am looking for books that can help to get well prepared for the exams.
Have found this two books in Amazon:
1 - MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, Second Edition
2- MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, 70-228, Second Edition
However their rating didn't encourage me to place directly my orders.
Does someone have any experience with them ?
Do you think they will considerably help me to add value to my knowledge of SQL Server and get ready for the exam ?
Do you know some others books you woul rather encourage me to buy ?
HiWe usae Sql2000.I'm setting up backups jobs and need advise.When I run a backup of a database, does it automatically clean out thetransaction log ? For a complete backup ? for a differential backup ?When would it be best to run a shrinkdatabase command ? Why would I wantto run the shrinkdatabase ?ThnaksDavid Greenberg
I am very new in SSIS. I have the Report Server set up with two dozen of the OLAP reports in it. The reports are connected to the OLAP database on a seperate computer running on Sql 2005 server and the data source for the OLAP DB is pointed to the warehouse database on another computer running on Sql 2000 server. The warehouse server updates daily from a number of "Production" Sql servers running on Sql 6.5 and Sql 7.0 with the legacy front-end data entry application. I know the update from the "Production" Sql 6.5/7.0 servers to the warehouse server complete around 9am in the morning everyday. How do I set up a package in SSIS to schedule the update of the OLAP database say 9:30am so that end-user can have the latest data to their report. The OLAP database has one fact table, half a dozen of cubes and ten dimensions. I know it is not an easy task to set up the package in SSIS. Please provide sample and step on how to do this. Thanks. One last question how to prevent/warn users from opening the report when SSIS updating the OLAP database?
I have a dimension table that, aside from its surrogate key (which is auto-generated using an identity column), has only one varchar column. I'd like to use an SCD Transform to insert only new output in the dimension, but this won't (?) work because I have no business key (the single varchar column comes from the SSIS pipeline), so my question is: how should I approach this problem? Is the design incorrect (e.g. should I generate the SK in the pipeline and use it as a business key?!), or am I doing something wrong in SSIS?
I am an Application Developer. I know just this about T-SQL : Insert, UPDATE, delete aRecord. JOIN tables. Create a Hierarchy column. execute MERGE Statement. [in order to create IDENTICAL tables .]
Create a Master-detail TABLE . [PrimaryKey-Foreig-Key]
WHAT ELSE SHOULD I KNOW widly speaking about T-SQL ??
What are ESSENTIAL things you should know to Be a BIT of an EXPERT ???
Hello,In my web application I am listing steps of action:STEP ACTION10 10.1 10.210.910.1010.203030.1etcHow should I set up my columns in my database? I tryed decimal but the problem is that 10.1 and 10.10 is in theory the same while in my case it is absolutely not. I also tryed nvarchar but does not sort correctly.Should I create 2 int column, one for the main step and another one for the sub-step (one would contain the part before the "." and the other would contain the part after the ".")?Thanks
Iam building a big site for video ( like youtube )
and I want to store the video url in the database because as I know that is the best choice
but my friend advised me to store all the video in the database for more security I know that will take alot of space in the database but he said ask the proffesionals
Dear All, I want to practise writing complex T sql queries in SQl Server 2005 which involve several joins, sub-queries in a single query. This kind of queries are commonly required in Reporting scenarios where a single report may have to be prepared from 2,3 or more tables. Presently I am able to write queries of moderate complexity. Therefore I am looking for web tutorials, books which contains some solved examples as well as some Unsolved ones. The Unsolved ones should have the answers given so that one comes to know if he makes a mistake. The web tutorials can be from paid sites as well. If any of you have a good collection of such queries then pls be kind enough to send it to me.I will give my email id for the purpose. If anybody can help in some other way pls let me know. Your help will be highly appreciated. Thanks .
Little rusty on my SQL but here is what I need. Currently have a stored procedure that returns numerical data for 8 different element readings. ( Carbon, Silicon, Sulfur, etc ). This data is then put into a datagrid on an asp.net page and shows the readings for each test.On my asp .net page... they only want data that is out of the specified ranges to be shown ( EX: > 1.6 AND < 2.0 ). Currently it is setup on the page to change the font color to red of data of its range but now they don't want data to be shown at all if for that one test everything is in its range.So how could I write my Where clause to check the 8 different element ranges and only need one of them to be true in order to show.Could I use an If / Then statement?Any help is appreciated.... Sorry this is quickly done but got to have it done soon.
need advise on the following: 1) when creating a new db, and specifying the file growth what is the advantage and disadvantage of choosing MB as oppose to percent. 2) i am in the process of moving MS Access tables to sqlserver, and my access database is setup with a workgroup security. Is it a good method to make use of NT authentication instead of SQLserver logins or use both? Considering some of my forms have tab controls that restricts certain groups of users.
I'm trying to write a SELECT INTO query to place the results into a new table. However when I try to run a statement where I create a new column AS 'column name' it gives me the following error: Msg 203, Level 16, State 3 The name 'Column Name' is not a valid identifier. Why is this not working? How can I create another table with the result of this info? EX s elect A.Mailbox_ID,C.Customer_Number,C.Customer_Name,A.M ailbox_Fee, convert (char(12),Setup_Date,107) AS "Setup Date", A.Setup_Charge,B.Amount_1 AS "Mailbox Rate" INTO #MBOX from Mailbox A,Rate_Codes B ,Customer C
Thank you. I need this important info for a project i need to complete.
I am trying to create a insert trigger that gets a value from the new record and use that to get additional data from other tables and update the new record
this is howfar i came:
create trigger trUpdateGEOData on BK_Machine after insert as update BK_Machine set BK_Machine.LOC_Street = GEO_Postcode.STraatID, BK_Machine.Loc_City = GEO_Postcode.PlaatsID from BK_Machine join GEO_Postcode on BK_Machine.loc_postalcode = GEO_Postcode.postcode, inserted where BK_Machine.MachineID = Inserted.MachineID and BK_Machine.Loc_Postalcode = GEO_Postcode.postcode and BK_Machine.LOC_Doornumber <= GEO_Postcode.van and BK_Machine.LOC_Doornumber <= GEO_Postcode.tem
Trigger runs fine but doesn't do a thing probably it can't find the machineid i think,
Hi All,I have a little scenario here, i am need of inserting some rows into atemp table which will be returned by a procedure... Here is littleexplanationI am planning to make a proc A and a temp table in proc A.I will be calling proc B from Proc A.What i want is the data returned by Proc B should be inserted into ProcA's Temp table.Can any one suggest me on this...A little help will be highly appreciated.ThanxCheers!
I dont know where to put this thread, I just wanna ask a question..actually what is happen when subscription synchronized the publications among IIS process.. (SQLMobile)
Hi friends i've a table that has 3 columns that refer to same parent table(foreign keys).am trying to following as part of action.
ALTER TABLE dbo.u_childTable ADD CONSTRAINT FK_childTable_MASTER_BATCHTO FOREIGN KEY ( FK_BATCHTO_MASTERID ) REFERENCES dbo.u_master ( MASTERID ) ON UPDATE NO ACTION ON DELETE NO ACTION
GO ALTER TABLE dbo.u_childTable ADD CONSTRAINT FK_childTable_MASTER_FEESCALER FOREIGN KEY ( FK_FEESCALER_MASTERID ) REFERENCES dbo.u_master ( MASTERID ) ON UPDATE set null ON DELETE set null
GO ALTER TABLE dbo.u_childTable ADD CONSTRAINT FK_childTable_MASTER_SUBDEBT FOREIGN KEY ( FK_SUBDEBT_MASTERID ) REFERENCES dbo.u_master ( MASTERID ) ON UPDATE set null ON DELETE set null
GO
but it wont let me complaining with following error "Introducing FOREIGN KEY constraint 'bl..blahh' on table 'childTable' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints."
i am developing a clinci software and i guess i reached to the most difficult part of it which is the appointment module.. I have made it as explaied below but not sure if i am doing it the right way or if i need to redesign my tables' structure.. please advise..
i have create doctors' duty table:
USE [shefa] GO /****** Object: Table [dbo].[staff_duty] Script Date: 11/16/2006 02:25:27 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[staff_duty]( [duty_id] [int] IDENTITY(1,1) NOT NULL, [staff_file_no] [int] NULL, [staff_name] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [duty_from] [datetime] NULL, [duty_to] [datetime] NULL, [record_locked] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_staff_duty_record_locked] DEFAULT ('N'), [created_date] [datetime] NULL CONSTRAINT [DF_staff_duty_created_date] DEFAULT (getdate()), [created_user] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [created_pc] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [created_version] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [created_domain] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [created_os] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [created_workingset] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_staff_duty] PRIMARY KEY CLUSTERED ( [duty_id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]
GO SET ANSI_PADDING OFF
and created the following appointments table:
USE [shefa] GO /****** Object: Table [dbo].[appointments] Script Date: 11/16/2006 02:26:51 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[appointments]( [appointment_id] [int] IDENTITY(1,1) NOT NULL, [appointment_guid] [uniqueidentifier] ROWGUIDCOL NULL CONSTRAINT [DF_appointments_appointment_guid] DEFAULT (newid()), [appointment_file_no] [int] NULL, [appointment_telephone] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [appointment_name] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [appointment_dr_id] [int] NULL, [appointment_dr_name] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [appointment_start] [datetime] NULL, [appointment_end] [datetime] NULL, [created_by_date] [datetime] NULL CONSTRAINT [DF_appointments_created_by_date] DEFAULT (getdate()), [created_by_user] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [updated_by_date] [datetime] NULL, [updated_by_user] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_appointments] PRIMARY KEY CLUSTERED ( [appointment_id] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]
GO SET ANSI_PADDING OFF
now i will need in C# to list the doctor's free time (means should be between his from and to in the staff_duty table and not listed in the appointments table for the dame day).. keeping in mind that each appointment should NOT take more than 15minutes.
I am implementing an application that is looking into another System’s database (DBF). I need to query out new orders that have been put in daily. What is the best way to handle this situation? Should I write a service or have a trigger setup in MSDE? I just need to do a simple SELECT statement that grabs orders between a date range and update my SQL database (MSDE). I am not looking for specific code examples, just a solution.
