+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, SIMs Monitoring in Technical; Im always being asked how can we tell if our SIMs server is working properly and determining/tuning SQL performance is ...
  1. #1

    m25man's Avatar
    Join Date
    Oct 2005
    Location
    Romford, Essex
    Posts
    1,608
    Thank Post
    49
    Thanked 444 Times in 330 Posts
    Rep Power
    136

    SIMs Monitoring

    Im always being asked how can we tell if our SIMs server is working properly and determining/tuning SQL performance is quite an art in itself but the chaps at ManageEngine have put together a pretty slick tool for free thats worth a try if only to satisfy your curiosity that all that money your LA charged you for your SIMS box was worth it..

    Free MS SQL performance monitoring Tool, Monitor MS SQL 2005, MS SQL 2008 server with Free SQL Health Monitor

    The Free Hyper-V Monitor is pretty good too but only lets you have 2 Host servers which is not a lot of use if you need to monitor a 3 node cluster from afar

  2. 6 Thanks to m25man:

    Butuz (14th February 2011), jinnantonnix (13th February 2011), matt40k (14th February 2011), rh91uk (13th February 2011), superfletch (13th February 2011), vikpaw (13th February 2011)

  3. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    I'll await Gin and Tonic's review ;P

    In the mean time, they appear to have quite a few pieces of freeware including a VMWare tool to monitor ESx, will have to check them out in the week.

    Free Enterprise Management Software - Network Performance Management, IT Help Desk & Desktop, Server Management

  4. 2 Thanks to vikpaw:

    Butuz (14th February 2011), jinnantonnix (13th February 2011)

  5. #3
    rh91uk's Avatar
    Join Date
    Sep 2008
    Location
    UK
    Posts
    862
    Thank Post
    137
    Thanked 132 Times in 114 Posts
    Rep Power
    35
    Ahyes, thankyou! I will be using this - a few issues here and there!

  6. #4
    Butuz's Avatar
    Join Date
    Feb 2007
    Location
    Wales, UK
    Posts
    1,579
    Thank Post
    211
    Thanked 220 Times in 176 Posts
    Rep Power
    62
    FANTASTIC!!!!!!

    Butuz

  7. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Quote Originally Posted by Butuz View Post
    FANTASTIC!!!!!!

    Butuz
    I know, something free AND really useful, it's the best thing since sliced EduGeek

  8. #6
    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    1,730
    Thank Post
    309
    Thanked 227 Times in 201 Posts
    Rep Power
    86
    Old Thread I know - but I've tried to use the free SQL monitor. I installed it on my PC and then put in the details of my SQL Server. The Health Monitor can connect to the server but states "SQL Server Version - Not Installed". I know its installed because its running SIMS!!!
    Its not the firewall as Ive tried it with server firewall off.
    Anyone any ideas?

  9. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Don't know, i have it linked to server same as you, it says not installed.
    What OS etc you got? Mine as per sig'
    The help says 'DBA will see ... ' so it implies you need to give dba access, i have windows auth, but it must not be going through.
    Maybe it needs to be on the server, or have that service installed locally that monitors SQL, was it the browser or agent or something on the old SQL that showed all SQL instances available. I'm not running SQL Management studio locally, are you? Might install that tomorrow and see how it goes.

  10. #8
    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    1,730
    Thank Post
    309
    Thanked 227 Times in 201 Posts
    Rep Power
    86
    Mine is Server 2008 R2, SQL 2008 R2, Physical Server with 16GB RAM. I ran it both on my PC and on the Server. Same thing. I have Management Studio installed but Im not really clued up on the inner workings of SQL so not sure what to look for.

  11. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    hi @fiza
    What OS is your client and what version of dotnet framework are you running? I'm win7 with 2, but trying 3.5.
    I'm talking to the company support team, so thought your info might help them too as on server side we're the same.

  12. #10
    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    1,730
    Thank Post
    309
    Thanked 227 Times in 201 Posts
    Rep Power
    86
    @vikpaw
    OS is XP SP3 and dotnet is 3.5

  13. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Apparently @fiza it's only designed to work on a default SQL instance and we no doubt have a named instance. No other issues.
    I've got some registry and wmi things to check but not sure it will help. Will get back to you tomorrow If I get any joy.

  14. Thanks to vikpaw from:

    fiza (8th February 2012)

  15. #12
    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    1,730
    Thank Post
    309
    Thanked 227 Times in 201 Posts
    Rep Power
    86
    @vikpaw
    We certainly do!!!
    Thanks for the detective work.

  16. #13

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Quote Originally Posted by fiza View Post
    @vikpaw
    We certainly do!!!
    Thanks for the detective work.
    No worries. It wont work. To use on a named instance we need SQLDBManager Plus which is a paid for product. Shame.
    Interested to know if @m25man or anyone else in the thread actually managed to use it.
    I've got a number of sql dbs for various little jobs, but i always use a named instance.

SHARE:
+ Post New Thread

Similar Threads

  1. Changing from Sleuth to SIMS for behaviour monitoring
    By IT_Man_Dan in forum MIS Systems
    Replies: 2
    Last Post: 28th March 2010, 06:22 AM
  2. Monitoring
    By Edu-IT in forum Windows
    Replies: 15
    Last Post: 21st September 2009, 11:00 AM
  3. monitoring
    By mac_shinobi in forum Scripts
    Replies: 0
    Last Post: 2nd June 2009, 11:04 AM
  4. IM monitoring
    By tom_newton in forum Network and Classroom Management
    Replies: 29
    Last Post: 5th November 2007, 09:33 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •