Forum Replies Created

Viewing 15 posts - 30,946 through 30,960 (of 49,552 total)

  • RE: SQL Server 2005 - Databases "not accessible" when service starts

    You do not want SQL using virtual memory. It uses memory to avoid having to go to disk, so using disk that's pretending to be memory is not a good...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 2, 2010 at 6:30 am

    #1215538

  • RE: SQL Server 2005 - Databases "not accessible" when service starts

    kfk (9/2/2010)

    I've tried setting them to various values, from 256MB to 4GB.

    While 256MB seemed to make the problem worse, I couldn't tell any difference between 2GB and 4GB.

    How much memory...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 2, 2010 at 5:13 am

    #1215514

  • RE: Optimize overall DB speed

    Maybe, but not necessarily. Doubtful that it will be significant if it does.

    The 32 bit app will run fine on a x64 OS, running under WOW (windows on windows). There's...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 2, 2010 at 4:57 am

    #1215503

  • RE: Clustered Index Seek is limiting factor in query

    Please post table definitions, index definitions and execution plan (a .sqlplan file) as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 2, 2010 at 4:37 am

    #1215491

  • RE: Optimize overall DB speed

    22GB is tiny. I have test databases bigger than that and they back up in minutes. Check your IO performance as that's about the only thing that affects backup speed....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 2, 2010 at 3:46 am

    #1215470

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/1/2010)

    If your contact email looked like mine, it was simultaneously a**-kissing and completely generic. The guy waxed prolific about how great I am and how qualified without ever...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 1, 2010 at 1:08 pm

    #1215236

  • RE: Are the posted questions getting worse?

    Alvin Ramard (9/1/2010)

    Gail, looks like your last post was #18,000

    Completely by accident as well...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 1, 2010 at 10:13 am

    #1215136

  • RE: transcation back up failed

    Please post new questions in a new thread.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 1, 2010 at 10:08 am

    #1215128

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (9/1/2010)

    GilaMonster (9/1/2010)

    BrainDonor (9/1/2010)

    Was August the month for SHRINKDATABASE and SHRINKFILE? The forums appeared to have these through them like a stick of sea-side rock for the past month.

    I'm surprised...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 1, 2010 at 9:55 am

    #1215110

  • RE: Possible schema corruption message when reindexing

    Does DBCC CheckCatalog return any errors?

    What's the exact version of this SQL instance (SELECT @@version)

    What options are on for that rebuild?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 1, 2010 at 9:02 am

    #1215059

  • RE: Does T1118 impacts all the databases

    All databases.

    Before enabling that, see if additional data files for TempDB helps. How many CPU cores and how many tempDB files do you have?

    Are you seeing contention on 2:1:3 on...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 1, 2010 at 7:46 am

    #1214964

  • RE: SQL Server 2005 - Databases "not accessible" when service starts

    kfk (9/1/2010)

    According to Microsoft, REPAIR_REBUILD "Performs repairs that have no possibility of data loss".

    Correct, but you should still not be running that to check for errors. To just check for...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 1, 2010 at 6:21 am

    #1214893

  • RE: SQL2K5: From Express to Professional: how ?

    Professional edition? There's no such edition of SQL.

    If you're talking about CLR assemblies, they're stored in the database and will come across with either method.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 1, 2010 at 6:17 am

    #1214892

  • RE: Where clause with nested loop join

    arup_kc (9/1/2010)

    Any idea how to proceed to this performance problem?

    First things first, remove the hint.

    If SQL is using a hash join it's because it thinks that there are too many...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 1, 2010 at 6:14 am

    #1214890

  • RE: Log Writer

    paul_johnson (9/1/2010)

    When running sp_who2 i note that the log writer is taking up 3011359 instances of CPU time.

    Is that high? How long has the instance been running? That CPU...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 1, 2010 at 6:12 am

    #1214888

Viewing 15 posts - 30,946 through 30,960 (of 49,552 total)