Advertisement

05.09.2008 at 02:36AM PDT, ID: 23388760 | Points: 500
[x]
Attachment Details
I want to find out %cpu utilization %memory %disk space of a ms sql database residing remotely in windows box from a linux operating system
There is a ms sql database in a window machine.  

I need to find the folowing of MS SQL server
1. % CPU
2. Memory details
3. disk space
However all this needs to be viewed from Linux.
Start your free trial to view this solution
Question Stats
Zone: OS
Question Asked By: Amit_Dogra
Question Asked On: 05.09.2008
Participating Experts: 4
Points: 500
Views: 0
Translate:
Loading Advertisement...
05.09.2008 at 02:53AM PDT, ID: 21531378

Rank: Guru

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.09.2008 at 03:03AM PDT, ID: 21531419

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.09.2008 at 03:06AM PDT, ID: 21531426

Rank: Guru

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.09.2008 at 03:11AM PDT, ID: 21531449

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.09.2008 at 03:13AM PDT, ID: 21531456

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.09.2008 at 03:22AM PDT, ID: 21531481

Rank: Guru

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.09.2008 at 03:44AM PDT, ID: 21531560

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.09.2008 at 06:32AM PDT, ID: 21532555

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.10.2008 at 06:25AM PDT, ID: 21538968

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
05.10.2008 at 05:40PM PDT, ID: 21541090

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Handhelds / PDAs
  • Displays / Monitors
  • Components
  • Networking Hardware
  • Peripherals
  • Laptops/Notebooks
  • Storage
  • Servers
  • Desktops
  • New Users
  • Misc
  • Apple
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMWare
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMWare
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Community Advisor
  • Lounge
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • Community Advisor
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
05.09.2008 at 02:53AM PDT, ID: 21531378

Rank: Guru

Hello Amit_Dogra,

You can use the top command
top -p <pid of sql processes>

Or you can check the information in /proc/pid/
cat /proc/pid/stat

Regards,
sunnycoder
 
05.09.2008 at 03:03AM PDT, ID: 21531419
there is a twist in this fairy tail.

 my ms sql is on a remote windows machine , I need to display %cpu , memory ,disk space from a java web application mounted on weblogic residing on Linux operating system.

So here we have interaction between windows and Linux. The point to note is that from Linux we need to pull this  % cpu , memory ,disk space of a ms sql database residing on windows os.

 
05.09.2008 at 03:06AM PDT, ID: 21531426

Rank: Guru

My bad .. I completely missed the windows part ... The information you seek can be obtained on windows machine programatically but I am sure there are much better ways that other experts can point to.
 
05.09.2008 at 03:11AM PDT, ID: 21531449
somebody please help
 
05.09.2008 at 03:13AM PDT, ID: 21531456
can linux get me information of a remote windows machine
 
05.09.2008 at 03:22AM PDT, ID: 21531481

Rank: Guru

Check pstools
http://technet.microsoft.com/en-us/sysinternals/bb896649.aspx

PsList would be of interest to you
http://technet.microsoft.com/en-us/sysinternals/bb896682.aspx

Basically you would need a setup where you execute psList on windows machine and transfer the output to Linux machine. Again there could be multiple ways of doing it.
There can be a script on windows machine that executes psList, redirects output to a file and then scp the file to Linux machine.
 
05.09.2008 at 03:44AM PDT, ID: 21531560
Is there any simple way actually the windows box where this ms sql database resides is a production database very critical And I dont want to mess around with it. Also if i use psList it  who would trigger it and then all its output needs to be transfered to a text file and then again ftp needs to be done of this text file from windows to linux. Please suggest a simple ways.
This is going to be complicated.


 
05.09.2008 at 06:32AM PDT, ID: 21532555
I would recommend nagios with npre.

You would run the npre daemon on the remote box and use the check_npre on the linux server.

I don't use npre so I would suggest the nagios mailing list -- it is an excellent list for nagios users:

https://lists.sourceforge.net/lists/listinfo/nagios-users
 
05.10.2008 at 06:25AM PDT, ID: 21538968
Could you vnc to the windows machine or is that too much overhead?  I think TightVNC might be your solution. www.tightvnc.com/download.html  There are VNC programs for both windows and Linux.
 
05.10.2008 at 05:40PM PDT, ID: 21541090
if the windows box has a web server on it, you could put a script on the website to return the parameters you want.
If snmp is enabled on the server you could query snmp for the values also.
 
 
20080236-EE-VQP-29 / EE_QW_2_20070628