Any Free Tool To Monitor SQL I/O, Network/sec

Jun 23, 2008

Hi Everyone,

I am looking for a tool which can store SQL I/O and network/sec data. According to this historical data, I can decide whether upgrade my hardware.

Is there any free tool?

View 3 Replies


ADVERTISEMENT

SQL Monitor Tool

May 20, 2007

Hi,

Our company is looking for SQL monitoring tool. Please give any recommendations.

Thx

View 3 Replies View Related

Free Tool For MSSQL Admin

Jul 10, 2007

I'm looking for a free tool akin to SQL Server Enterprise Admin that i can use to administrate some of my databases on remote hosting from my home PC... any recommendations?

View 2 Replies View Related

Free Query Tool From AgileInfoSoftware

Aug 17, 2005

AgileInfoSoftware LLC is proud to announce AgileInfoSoftware PowerQuery*4.1 release. PowerQuery is free database query tool to work with multiple databases simultaneously and effectively.

The key features of PowerQuery 4.1 are:
One unified user interface works with*all your databases. No need to switch from one database to another.
Easy to build and execute query.
Use native database connectivity to improve database query performance.
Graphical*table edit and commit change without writing any INSERT, UPDATE or DELETE statement.
Automatically monitor Oracle Server side activities, such as executed SQL statements, server memory usage, disk usage and many other performance measurements

To obtain free PowerQuery 4.1, go to http://ww.agileinfollc.com. After download and install the software, send the registration code (32 bytes hash string generated based on your installation time) to support@agileinfollc.com, we will send back free license code to activate the software permanently.

View 1 Replies View Related

Any Free Reporting Tool You Recommend?

Nov 6, 2006

dun need sophisticated interactive reports, but just simple basic rigid reporting will do :D

looking for a simple tool for my end users. Crystal Reports a bit overkill.....

View 10 Replies View Related

Free Administration Tool For SQL SERVER 6.5

Mar 30, 2004

Hello,

I need an Administration tool for SQL SERVER 6.5 compatible with WINDOWS 2000.

When I try to search one with GOOGLE, I find none ...

If anyone can provide me with any solution, he (or she) will make me the most happy of the DBAs today ...

Thanks in advance

Al'

View 1 Replies View Related

SQL Stripes - Free SQL Server Monitoring Tool

Sep 25, 2003

http://stripes.docmusic.com

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

Thanks and enjoy!

View 3 Replies View Related

(free) SQL Server Mgmt Tool For Linux

Apr 23, 2008

I have a Linux machine here at work that I do some development on, along with a few other tasks. It's also on my primary machine at home. Is anyone aware of a SQL Server Management suite that will run (natively - not in a VM) on Linux? I've used Aqua Data Studio in the past, but I would rather not have to pay for another License just for a part-time use.I'm not looking for a full suite of graphical utilities. If I could get the basic functionality of Query Analyzer (query window, object scripting, etc..), I'll be happy.I've googled around, and the pickings have been rather slim. The only thing I've found is something called Transact-SQL Analyzer (http://sourceforge.net/projects/sqlanalyzer/). I haven't tried it yet, but I'll give it a shot. Has anyone used it before? It doesn't make mention of 2k5 support, either.

View 6 Replies View Related

Is There A Free Intellisense Tool For SQL Server Stored Procedures?

May 14, 2008

I was looking for a 'free' intellisense tool that will prompt me with options when I am writing stored procedures in SQL Server Studio. Very much like the intellisense in Visual Studio.
Does someone know about such a tool? I know there are tools of this type but they cost 600 to 1000 dollars for a single user.
 

View 2 Replies View Related

Is There A FREE, Pure Web Based Backup Restore Tool ?

May 10, 2008

HI

I am trying to find a pure web based backup restore tool that can be used on MS SQL 2000.

I have found a few that claim to be web based, but then it tells you to log into your MS SQL server and make some adjustments.

I know that microsoft Enterprise manager comes with a backup / restore tool. but 1) i dont want to have to install a complete copy of 2005 server, and 2) i dont hav ethe physical space to do it right now anyway. all i need to do is move 2 databases from one account to another.

thanks

View 3 Replies View Related

Setup And Upgrade :: Activity Monitor Shuts Down If Connect To Instance Its Monitoring With Performance Monitor

Aug 19, 2015

If I'm on a remote machine, meaning a computer not in the WSFC cluster, and I open SSMS 2014, point it to a SQL Instance, and open activity monitor:

1.  I get all the panes and charts except % Processor Time.

2.  Then, if I authenticate to the cluster's domain by mapping a drive with valid domain credentials, I'm free to put performance counters in the Perfmon - - - but SQL Activity Monitor shuts down with“The Activity Monitor is unable to execute queries against server SQL-V01INSTANCE1..Activity monitor for this instance will be placed into a paused state.Use the context menu in the overview pane to resume the activity monitor.

Additional information:  Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))(Mscorlib)”

3.  Of course, the Activity monitor can't be resumed via the context menu. Removing counters and closing the perfmon do not work.  I dropped the mapped drive and rebooted the machine.  That brought back 95% of the information in the Activity monitor.

4.  Further experimentation showed that any mapping of drive shares present on the SQL Server to the computer running SSMS cut off functionality of the 'overview' pane in the remote machine's SQL Activity monitor -- the monitor that had been trying to watch the server offering the shares.

View 4 Replies View Related

Red X Show On Replication Monitor (publications Is Disconnected From Replication Monitor)

Jan 30, 2007

I have setup transactional replication everything on one box. later(two or three weeks later), Replication monitor is show red X Under my publishers (publications is disconnected). this is SQL2005.

Everyone known how to fix this problem?

Thanks,

Frank

View 1 Replies View Related

Asp.net Confgiguration Tool. Tool Keeps Timing Out

Mar 2, 2006

is it possible to change the settings on this tool. i want to have it so that it does not time out at all? or is that possible??

View 1 Replies View Related

[DBNETLIB][ConnectionRead (recv()).]General Network Error. Check Your Network Documen

Sep 30, 2004

Hello all,

We have a Windows 2003 Web Edition server serving a site through IIS. It connects to a Windows 2003 Standard Edition server running SQL 2000 SP3a.

This site receives the following error as seen in the topic:
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.

We've configured the server network utility to only allow TCP/IP connections. The connection string for the site is as follows:

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_connSpankMSSQL_STRING = "Provider=sqloledb;Data Source=SERVER_IP,1433;Network Library=DBMSSOCN;Initial Catalog=ourmaindb_1;User ID=ourmaindb_1;Password=hotcookies;"
%>

Any ideas or tips on solving this issue? We've noticed it is due to larger queries as smaller ones do work with no problems.

The servers are behind a BSD box running iptables, has 1433,1434 along with standard web ports wide open. Anything outbound is allowed.

Some further testing via ODBC on the IIS server improved things. No more connection pooling for the SQL Server driver allows for 1/3 of the query to run. Still 2/3s of it doesn't show up, and that general network error message appears.

Should have 330 rows if it works right.

View 2 Replies View Related

[DBNETLIB][ConnetionWrite (WrapperWrite()).]General Network Error. Check Your Network

May 19, 2004

Hi
While running a DTS, many times the error message: "[DBNETLIB][ConnetionWrite (WrapperWrite()).]General network error. Check your network documentation." appears.
Does somebody knows why?

I am running the DTS from a computer (not the server where the DTS is stored) and it is connected without any problem when this happens.

Thanks!!
Regards
Lautaro - Argentina.

View 4 Replies View Related

ASP.Net 1.1 With SQL 2005 : General Network Error. Check Your Network Documentation

Oct 4, 2007

Hi Every one,

I am using .Net 1.1 for my web application.

And my database server is SQL Server 2005.

My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,

General Network Error. Check your network documentation


I have also searched many articles and tried following solutions but nothing working

- connectiontimeout = 0, max pool size = 7500/100, pooling = false

- SSL disabling enforce security false as mentioned in microsoft kb article.

And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string)

Can any one please help me to solve this error?

With Regards,

View 3 Replies View Related

General Network Error. Check Your Network Documentation

May 26, 2007

Hi We have a written a error log in Global.asax. which capture below mentioned error in the prodcution server. Same applications is working fine in some locations and some loactions we are getting the error.Any body knows why this error is occurs.Any body knows why this error is occurs. Error Message:General network error. Check your network documentation.Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin() at System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection connection, SqlConnectionString connectionOptions) at System.Data.SqlClient.SqlConnection.Open() at datalayer.sqldb.Execute(String ProcedureName, SqlParameter[] Parameters) at lms.User.GetUserDetails(String strUserid)ITs at LMS.Login.w_btn_Login_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

View 2 Replies View Related

General Network Error. Check Your Network Documentation

Oct 4, 2007

 Hi,I am using .Net 1.1 for my web application.And my database server is SQL Server 2005. My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,General Network Error. Check your network documentation  I have also searched many articles  and tried following solutions but nothing working- connectiontimeout = 0, max pool size = 7500/100, pooling = false- SSL disabling enforce security false as mentioned in microsoft kb article. And there's  nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string) Can any one please help me to solve this error? 

View 2 Replies View Related

General Network Error. Check Your Network Documentation

Feb 8, 2004

When I try to update the site setting, I get this Error and I don't know how to fix.

Server Error in '/DotNetNuke' Application.
--------------------------------------------------------------------------------

General network error. Check your network documentation.
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.

Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation.

Source Error:


Line 281:
Line 282: myConnection.Open()
Line 283: myCommand.ExecuteNonQuery()
Line 284: myConnection.Close()
Line 285: End Sub


Source File: C:DotNetNukeComponentsAdminDB.vb Line: 283

Stack Trace:


[SqlException: General network error. Check your network documentation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +721
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +196
DotNetNuke.AdminDB.UpdatePortalInfo(Int32 PortalId, String PortalName, String PortalAlias, String LogoFile, String FooterText, Int32 UserRegistration, Int32 BannerAdvertising, String Currency, Int32 AdministratorId, String ExpiryDate, Double HostFee, Double HostSpace, String PaymentProcessor, String ProcessorUserId, String ProcessorPassword, String Description, String KeyWords, String BackgroundFile, Int32 SiteLogHistory) in C:DotNetNukeComponentsAdminDB.vb:283
DotNetNuke.SiteSettings.Update_Click(Object sender, EventArgs e) in C:DotNetNukeadminPortalSiteSettings.ascx.vb:287
System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

Please Help!

Thank you,

dlouanis

View 2 Replies View Related

General Network Error. Check Your Network Documentation

Jan 9, 2006

I use sqlclient to connect directly from my mobile 5 pocketpc to a sql server 2005 database on my desktop.

I use a sqldatareader to traverse the results of a query that delivers 2 fields: (1) the filespec, and (2) the image field.

I use a filestream with a binary writer to write the contents of the image data to the pocketpc's storage card.

I have a test table with 10 images, not one more than 4 MB.  I cannot complete a test run prior to receiving the  general network error.

The pocketPC is connected via activesync to the desktop, and I connect to the database with:

Integrated Security=false;
user id=sa
password=admin.

Any help with this strange error would be greatly appreciated.

Wil

View 5 Replies View Related

General Network Error Check Network Documentation

Oct 11, 2006

Hi I get a "General Network Error Check network documentation" error sometimes, but its only while insert or update statements are fired while selects keep working perfectly.

The Error details are as follows:
General network error. Check your network documentation.
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.
Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:

[SqlException: General network error. Check your network documentation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

View 1 Replies View Related

Looking For A Tool/ Middleware Tool Which...

Jul 23, 2005

Hi all.I'm looking for a tool which should act like some kind of middleware/logical layer bewtween the SQL server and the webbased user interface.- It should be possible to easily create simple web forms (only datainput and output) without programming effort by "clicking" the fieldsand their order on the web mask within an admnistrative interface.- It should also be bossible to add "new fields" to the database,including field type, permissions, value lists etc. (excluding anybusiness logic) without programming effort by administration.I know, that most workflow tools or "Trouble Ticket Tools", based ondatabases have this feature to easily configure new masks and add newfields to the database, but i need it as an tool-unspecific layer forthe MS SQL Server.Thank you very much for your feedback, any ideas are welcome!Best regards, Heiko.

View 1 Replies View Related

General Network Error. Check Your Network Documentation. Error Number 11

Aug 16, 2005

  Hi,I am getting the following error (When i am trying to update the column thru windows service) Please let me know the solution for the following.The following error is comming only when i set CommandTimeout to infinity (Commandtimeout=0).General network error.  Check your network documentation. Number 11 Procedure ConnectionRead (recv()). Class 20 State 0 Source .Net SqlClient Data Provider Server  Line number 0 Thanks and Best RegardsNagaraju A

View 2 Replies View Related

What Is Client Network And Server Network Alias In SQL Server.

Jul 28, 2007



Hi all,

What is client network and server network alias in SQL server.

when and why we should use that mean what is the requirement of ALIAS in SQL Server.

Thanks

View 5 Replies View Related

Free T-SQL IDE ??????

Mar 29, 2008

hi,
does any one know about a free T-Sql IDE with fully functional
intellisense ???????????

thanx in advance

San

View 2 Replies View Related

SQL - Is It Free

Mar 5, 2008

I would like to make sure that SQL Server Express is completely free even for public institutions e.g. bailiff office. We (my office) want to use SQL Server Express 2005 at 9 computers for free, is it possible? Can you give me a full answer? Thanks!

View 1 Replies View Related

How About A Free One?

Apr 4, 2007

Surely not everyone that uses SQL on a shared server has to buy their own copy of SQL Server?



Is there a free utility to copy it from the host to local? I am assuming that SQL management express can not do this (after searching the help for a while... annoying)

View 5 Replies View Related

Free Up Memory

Jan 6, 2006

Good day.

I'm executing a stored procedure, before execution the memory used for sqlservr.exe in the task manager reflects about 50mb. but after the stored procedure is executed, the memory used by sqlservr.exe boosts up to 200mb and remains at 200mb even after execution. this causes my pc to slow down. how dow i reset the memory used by sqlservr.exe after executing the stored procedure? any help will be very much appreciated. thank you.


waling

View 2 Replies View Related

Free Code

Feb 10, 2005

Hello, I am 13 years old and trying to create a mmorpg(massively multiplayer online role playing game) and need a database so people can register, buy weapons, kill other people, etc. The only problem is, I only know javascript and html. I was wondring if anyone had free code for MS Server 2000 that users of my game register, and it records the users username, password, etc.
Thanks so much,

-tyler

View 10 Replies View Related

Free GUI For SQL Server

Jan 20, 2004

Is there a Free GUI for SQL server that can control or edit any and all the records in it, and the tables?

View 2 Replies View Related

Free Space

May 7, 2008

xp_fixeddrives gives the free space on the server drives. Is there a xp which gives the actual size of the drive?

I need to calculate the %space used!

------------------------
I think, therefore I am - Rene Descartes

View 3 Replies View Related

Free Intellisense?

Jan 11, 2008

Greetings!

I'm not sure where to post this question but this place seams to fitt best.

I'm wondering about intellisense's that are free ang good for sql 2005 and 2008. I tried to google it and I tried to search for it in here but didnt find something good. I only find products that aint free and atm that aint an option actually.

So do any of you know some free goog intellisense for sql 2005 and/or 2008?

Thanks

View 2 Replies View Related

Is There A Free Ms Sql Host?

Oct 5, 2006

I am looking for a free ms sql database for my programs, but i don't want to host it on my computer, because my web host does not allow servers to be run and people connecting to thme.

View 1 Replies View Related







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