Forum Replies Created

Viewing 15 posts - 46 through 60 (of 77 total)

  • RE: Bar graph in reporting services

    I am not sure i understand what you mean by not being able to make the relation between X and Y.. this relation should be made in the source data.....

    Oraculum

  • RE: SQL Server 2005 SP3

    Can we have a new forum entry for Service Packs or SP3 so that we can all have one place to add our comments and results in the installation of...

    Oraculum

  • RE: CPU 100% and critical

    some of my rs reports - cpu was normal all weekend and all day monday... then its starts to become eractic, the resting sql CPU is 10% which is unusual...

    Oraculum

  • RE: CPU 100% and critical

    cost threshold is set to 5

    Oraculum

  • RE: CPU 100% and critical

    MAXDOP = 0

    Hyperthreading...i'm not sure.. how can i tell?

    Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)

    Feb 9 2007 22:47:07

    Copyright (c) 1988-2005 Microsoft Corporation

    Enterprise Edition on Windows NT...

    Oraculum

  • RE: CPU 100% and critical

    here are the results from the two querys...

    am wondering whether to restart sql agent....umm..

    have also just noticed something has changed with my tempdb config (i have been off work for...

    Oraculum

  • RE: CPU 100% and critical

    will see if occurs again tomoz.. i did just find this post which sounds very very similar though ... will post tomoz when i am back at work! thanks

    qa.sqlservercentral.com/Forums/FindPost472093.aspx

    Oraculum

  • RE: CPU 100% and critical

    SOS_SCHEDULER_YIELD is the another prominent wait event that shows up...

    Oraculum

  • RE: CPU 100% and critical

    In reply to above - yes task manager and perfmon - all show SQL Server at around 96-99% then 1%+ left to other services running.

    I use idera so i can...

    Oraculum

  • RE: CPU 100% and critical

    something even stranger... when i run a sql profiler as soon as i press 'run' on start trace the cpu on the server drops down to around 30-40% - but...

    Oraculum

  • RE: Performance Implications of Database Snapshots

    Is the snapshot functionality mentioned here the same that is used for snapshot replication? do the same issues apply for this if you run the replication once a day on...

    Oraculum

  • RE: SQL Server 2005 SP3

    luckily we have (so far) managed to not apply CU's as we have only hit minor issues mainly with SSIS packages...so we are holding out for the SP3! it...

    Oraculum

  • RE: SQL Server 2005 SP3

    heres some of the announcements....thanks everyone for Voting! i think they actually had to listen!

    Microsoft to Offer SQL Server 2005 SP3

    Wednesday, April 16, 2008 12:00 PM PDT

    Microsoft will release a...

    Oraculum

  • RE: SQL Server 2005 max memory and /3GB switch

    ok, still some conflicting info... so can you help me with this specific..

    Currently have 4GB RAM - SQL using around 1.6/7GB on each node.

    Installing 8Gb on each node.

    What settings...

    Oraculum

  • RE: database deleted - need to find out when and who - is it logged?

    luckily a trace was being performed and i have caught the dbcc detach command and know when and who! Thanks 😉

    Oraculum

Viewing 15 posts - 46 through 60 (of 77 total)