+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 22
MIS Systems Thread, [SIMS / SQL2008] Show us your Perfmon! in Technical; sql2008perfmon.jpg Hey People, Would anyone mind comparing SQL 2008 perfmon? running sims...
  1. #1

    Join Date
    Jul 2009
    Posts
    273
    Thank Post
    6
    Thanked 43 Times in 37 Posts
    Rep Power
    16

    [SIMS / SQL2008] Show us your Perfmon!

    sql2008perfmon.jpg

    Hey People,


    Would anyone mind comparing SQL 2008 perfmon?

    running sims

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,427
    Thank Post
    368
    Thanked 643 Times in 525 Posts
    Rep Power
    159
    Is that normal load? Looks like someone needs faster CPUs (assuming I'm not being stupid... again)

  3. #3

    Join Date
    Jul 2009
    Posts
    273
    Thank Post
    6
    Thanked 43 Times in 37 Posts
    Rep Power
    16
    hi MAtt, this is taken at busist point of day, CPU = xeon 2.ghz ( four cores) x3220.
    Just wondering what else people have...

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,427
    Thank Post
    368
    Thanked 643 Times in 525 Posts
    Rep Power
    159
    In Suffolk alot of schools have (or had) Dell 1430, fitted with Xeon E5310 - E5335, so it'll give your server a run for your money and they're about 5 yrs old!!

    Most highs have replaced kit with DL380, dual quad xeon and 12gb+ ram last year - must have been a offer on

  5. #5

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,985
    Thank Post
    114
    Thanked 505 Times in 340 Posts
    Blog Entries
    2
    Rep Power
    286
    Try SQL Acitivity Monitor instead of perfmon; it will give you a better view of your SQL operations.


    Launch SQL Management console, then right-click your server in Object Explorer and choose Activity Monitor.

    High CPU usage can be difficult to troubleshoot, as many things can cause the problem. For instance, if the server is paging a lot, it will cause high CPU load. This can be caused by insufficient memory, or unusable memory from a leak. Or even an intensive process!
    Pay attention to the Recent Expensive Queries pane, open this up and see what's chewing up your server.

    I wrote a little script to look at the highest CPU users over a period of time (I've set two minutes, but change it if you like)
    SQL Server CPUs at 100%
    Last edited by jinnantonnixx; 13th July 2011 at 02:17 PM.

  6. #6

    Join Date
    Jul 2009
    Posts
    273
    Thank Post
    6
    Thanked 43 Times in 37 Posts
    Rep Power
    16
    thanks jinnantonnixx
    Does This mean anything to anyone?
    I;m guessing it just havsn't got eh CPU required but i maybe wrong sqlactmon.jpg

  7. #7

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,985
    Thank Post
    114
    Thanked 505 Times in 340 Posts
    Blog Entries
    2
    Rep Power
    286
    That third row looks like 101 million reads per second! What's going on there?

    Time to get detective-y....

    If you right click a nasty query > select 'Edit Query Text'. This will open a new page with the expensive query in all its glory.

    Next, we need to find out what called it and where it came from.

    This is a bit tricky, so let's see what we can do...

    Right, this bit of code will locate a stored procedure from a bit of text you provide. This is quite handy for things like debugging using Profiler.

    So, copy a significant portion of the query text, and paste it into this query (I highlighted it blue)

    Code:
    -- change this
    use [your_SIMS_database_name]
    
    declare @Search as nvarchar(1000)
    
    
    --paste your query sample here don't forget to enclose the whole deal with a single quote.
    select @Search='	< paste your query sample here > 
    	< leave all spaces and line breaks alone >
    	< its fine for a query to be on several lines >'
    
    
    
    SELECT Name
    FROM sys.procedures
    WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%' + @Search + '%'
    GO

    Like I said, it's a bit hit and miss but it should show you what's causing your bottlenecks.
    Last edited by jinnantonnixx; 13th July 2011 at 03:44 PM.

  8. #8

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,985
    Thank Post
    114
    Thanked 505 Times in 340 Posts
    Blog Entries
    2
    Rep Power
    286
    On second thoughts, it's probably more straightforward for you to run the query I wrote here: SQL Server CPUs at 100%

    This will prob give you more useful info, such as user and workstation, from which you can narrow down the likely suspect.

  9. #9

    Join Date
    Jul 2009
    Posts
    273
    Thank Post
    6
    Thanked 43 Times in 37 Posts
    Rep Power
    16
    ok have the results, shall i post them or what am i loking for?

  10. #10
    Butuz's Avatar
    Join Date
    Feb 2007
    Location
    Wales, UK
    Posts
    1,579
    Thank Post
    211
    Thanked 220 Times in 176 Posts
    Rep Power
    63
    Yeh that reads per second looks wrong.

    4 cores should be ok for most installations 8 cores would be ideal if your a very heavy user and large school. I am only using 4 3.2Ghz cores on mine and although it does hit 100 fairly often during the day it is only for spit seconds each time and it far from sustained like yours. We have up to 100 concurrent users and run SIMS / FMS / SIMSDISCOVER / Learning Gateway and Partnership exchange so our SIMS server is given quite the beating.

    Ill post a screeny of mine from registration tomorrow.

    Butuz

  11. #11

    Join Date
    Jul 2009
    Posts
    273
    Thank Post
    6
    Thanked 43 Times in 37 Posts
    Rep Power
    16
    thanks butuz , sounds like a similar setup, would you mind comparing SIMS sizes too? my sims.ldf is 14GB and sims.mdf is 2.7 GB , im sure somethings not right somewhere. going to run that script tomorrow at a busy time to see who is doing what

  12. #12

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,985
    Thank Post
    114
    Thanked 505 Times in 340 Posts
    Blog Entries
    2
    Rep Power
    286
    Your LDF is too big. This normally means that either your backup isn't working, or your backup has had problems in the past and your log file hasn't been shunk down to size.

    Surprisingly, a gynormous log file doesn't put too much strain on the server; it's a file that's written sequentially and doesn't get loaded into memory. Not all of it, anyway!

    You should make checking your backups a priority, then take a look at the log file.

    You can see the status of the log file with this query.

    Code:
    use [your_SIMS_database]
    go
    
    SELECT	Name, Filename,
    
    CONVERT(Decimal(15,2),ROUND(a.Size/128.000,2)) [Currently Allocated Space (MB)],
    
    CONVERT(Decimal(15,2),ROUND(FILEPROPERTY(a.Name,'SpaceUsed')/128.000,2)) AS [Space Used (MB)],
    
    CONVERT(Decimal(15,2),ROUND((a.Size-FILEPROPERTY(a.Name,'SpaceUsed'))/128.000,2)) AS [Available Space (MB)]
    
    FROM dbo.sysfiles a (NOLOCK)
    Look at the results and see if the space used by the log file is close to the space allocated.
    Last edited by jinnantonnixx; 13th July 2011 at 04:59 PM.

  13. Thanks to jinnantonnixx from:

    andydis (14th July 2011)

  14. #13
    Butuz's Avatar
    Join Date
    Feb 2007
    Location
    Wales, UK
    Posts
    1,579
    Thank Post
    211
    Thanked 220 Times in 176 Posts
    Rep Power
    63
    SQL1.jpg

    Here's mine over registration period. This isn't as busy as usual here as a fair few kids are out but one thing to note is Logical reads per second never went over 20,000 on any query.

    Butuz

  15. #14
    Butuz's Avatar
    Join Date
    Feb 2007
    Location
    Wales, UK
    Posts
    1,579
    Thank Post
    211
    Thanked 220 Times in 176 Posts
    Rep Power
    63
    And datafile usage

    SQL2.jpg

    Butuz

  16. #15

    Join Date
    Jul 2009
    Posts
    273
    Thank Post
    6
    Thanked 43 Times in 37 Posts
    Rep Power
    16
    Ok now I know theres a problem looking at the comparison :-(


    Heres my top 10 running the script

    http://www.helpdesksupport.co.uk/sims.csv


    Server is still very HIGH CPU useage.


    regarding the backup. it has been successful.
    However the way i think it is done is :-

    When you right click the sims database ALL tasks > backup > full backup. I think this is automated daily and then this goes to tape.

    The LEA is reasponsible for this server and so i am going to ring them to see if i can esculate this as its getting abit beyond me but any extra input is appreciated,.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Would you like to help and show us your tech?
    By Ric_ in forum General EduGeek News/Announcements
    Replies: 28
    Last Post: 23rd March 2010, 10:51 AM
  2. Show us your office space(/s)
    By p858snake in forum General Chat
    Replies: 19
    Last Post: 3rd July 2009, 09:03 PM
  3. Want a job? Then give us your passwords!
    By adameye in forum IT News
    Replies: 15
    Last Post: 25th June 2009, 09:01 AM
  4. SHOW OFF YOUR VLE HERE
    By thegrassisgreener in forum Virtual Learning Platforms
    Replies: 13
    Last Post: 19th October 2007, 10:12 PM

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
  •