Forum Replies Created

Viewing 15 posts - 31 through 45 (of 153 total)

  • RE: SAN Response Times

    Andrew G (1/19/2015)

    High buffer I/O just means high logical IO which is probably just missing indexes or poor performing queries due to the amount of data being processed.

    For example, you...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

    January 20, 2015 at 1:21 am

    #1771311

  • RE: How to buffer more data for longer time

    Has 'locked pages' in memory configured for this server?

    If there are non sql or non buffer pool activity that require more memory it might be clearing it earlier too?

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

    January 9, 2015 at 7:11 pm

    #1769224

  • RE: Which is used MAXDOP of Resource Governor or SQL Instance Max Degree Parallelism setting?

    Thanks Gail!

    I think I will have to 're-run' my testing, I used the following to check for parallel plans.

    SELECT TOP 50

    OBJECT_NAME(p.objectid, p.dbid) as [object_name]

    ,ps.total_worker_time/ps.execution_count as avg_worker_time

    ,ps.execution_count

    ,ps.total_worker_time

    ,ps.total_logical_reads

    ,ps.total_elapsed_time

    ,p.query_plan

    ,q.text

    ,cp.plan_handle

    FROM sys.dm_exec_procedure_stats ps

    INNER JOIN sys.dm_exec_cached_plans...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

    December 5, 2014 at 11:49 am

    #1763053

  • RE: Script that identifies the Percent Complete of a Restore, etc

    Welsh Corgi (12/5/2014)

    I had a script that identifies the Percent Complete of a Restore, etc.

    I can not find it.

    Any help would be greatly appreciated.

    Thanks.

    Kent

    I got this from some where and...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

    December 5, 2014 at 11:25 am

    #1763046

  • RE: Another VM Sertup Question With SAN

    JoshDBGuy (12/3/2014)

    So it doesn't look like we use RDM. Basically we have storage assigned to a host and then spread out that storage among virtual machines.

    Hi Josh not sure if...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

    December 3, 2014 at 1:41 pm

    #1762511

  • RE: Puzzle with Sproc intermittently runs slow but runs faster other days.

    Thanks SpaghettiaDBA and ScottPletcher for your feedback! I appreciate it 😀

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

    December 3, 2014 at 11:19 am

    #1762480

  • RE: Puzzle with Sproc intermittently runs slow but runs faster other days.

    spaghettidba (12/2/2014)

    Stale statistics could be the cause.

    Plans compiled against stale statistics are more likely to be sub-optimal.

    That's a possibility thanks!

    So maybe the long running plan was using stale stats......

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

    December 2, 2014 at 7:41 pm

    #1762262

  • RE: DBCC CHECKDB keeps running every night

    tpsharp (12/2/2014)

    Hi,

    There are definitely VM snapshots occurring, I will check out and see when they run to see if this is causing this.

    Many thanks everyone for your help.

    This normally happens...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

    December 2, 2014 at 4:40 pm

    #1762250

  • RE: Puzzle with Sproc intermittently runs slow but runs faster other days.

    spaghettidba (11/21/2014)

    Looks like bad parameter sniffing and/or stale statistics.

    Here's a good article on the subject: http://www.mssqltips.com/sqlservertip/3257/different-approaches-to-correct-sql-server-parameter-sniffing/

    Thanks for reply and link. I would think so too, but if the cache is...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

    December 2, 2014 at 4:11 pm

    #1762246

  • RE: What would cause index REORGANIZE to take longer than index REBUILD?

    Interesting :unsure:

    Are your drives separated by

    LOG

    DATA

    If so, could it be possible the LOG drive is slower than DATA drive?

    I know that for rebuild and reorg there is log...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

    November 7, 2014 at 4:54 pm

    #1757276

  • RE: Query to compare two databases

    Priya004 (9/18/2014)

    Hi,

    Need a query to compre two database schemas.

    I have seen lot of comparision tools but need a query.

    Thanks

    Do you have replication installed on a (it can be any) SQL...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

    September 19, 2014 at 2:55 am

    #1746618

  • RE: Reduce locking for Insert statement?

    GilaMonster (9/11/2014)

    sqlsurfing (9/10/2014)

    I think i'll focus on working w/developer on any tweaks first on that blocking sproc first.

    Good idea. Can't see anything in the code you...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

    September 19, 2014 at 2:52 am

    #1746616

  • RE: Page Compression

    TomThomson (12/7/2010)

    BoL is wonderfully ambiguous on this. One can go with the definition that says Page Compression is the whole thing, including Row Compression, or one can go with the...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

    September 15, 2014 at 7:28 pm

    #1745646

  • RE: SYS.DM_EXEC_REQUESTS gives different information

    pawana.paul (9/10/2014)

    Hello,

    To analyze the performance data I am inserting SYS.DM_EXEC_REQUESTS DMV result into table. Under the Command column, it shows CREATE INDEX entries, under Text column it shows insert [dbo].[tblName1]...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

    September 10, 2014 at 9:03 pm

    #1744627

  • RE: Sql Server Agent Job

    i_amhers (9/10/2014)

    Hi Ramana,

    Without reading the transaction log and/or log backups (which may be impossible, if msdb is set to the default simple recovery), I am not sure there is a...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

    September 10, 2014 at 8:58 pm

    #1744626

Viewing 15 posts - 31 through 45 (of 153 total)