Forum Replies Created

Viewing 15 posts - 1 through 15 (of 156 total)

  • RE: Query to compare indexes

    Lynn Pettis (3/17/2016)

    I am going to say that it depends on what your are trying to accomplish. Your question is actually a little vague on what you are trying...

    March 17, 2016 at 10:50 am

    #1865932

  • RE: Memory recommendation

    GilaMonster (3/17/2016)

    sunny.tjk (3/16/2016)

    I'm thinking we are having a high MAXDOP value of 8( MSFT recommends 3) due to which we are seeing high CXPacket waittypes.

    Nope!

    Oh, and CXPacket isn't a problem....

    March 17, 2016 at 8:22 am

    #1865869

  • RE: Memory recommendation

    Grant Fritchey (3/15/2016)

    What the other people have said...

    CXPacket is only a concern if you also see other CPU waits. The one thing I will say, sight unseen, if your Cost...

    March 16, 2016 at 4:37 pm

    #1865751

  • RE: Memory recommendation

    Grant Fritchey (3/14/2016)

    I doubt there's a document to support that. It's a bad estimate. I've successfully run 200gb databases on servers with 16gb of memory. It really depends on the...

    March 14, 2016 at 3:48 pm

    #1865077

  • RE: Huge OLTP database

    BL0B_EATER (1/13/2016)

    The only other thing I can think of is DB mirroring and create a snapshot off the mirror for reporting needs...caveat is if you need more recent data available...

    January 13, 2016 at 4:23 am

    #1851526

  • RE: Huge OLTP database

    Ian Scarlett (1/13/2016)

    Have you tried tweaking the Replication Agent Profiles? Specifically, the CommitBatchSize and CommitBatchThreshold values.

    The default values for these can group a lot of publisher...

    January 13, 2016 at 4:21 am

    #1851525

  • RE: Transactional Replication issue

    Replication is set up using backup not snapshot.

    I loaded the table from production into data warehouse. I'm having this problem only while adding it back into replication.

    January 3, 2016 at 5:46 pm

    #1849124

  • RE: Can't log into SQL Server

    DBAHeels (3/27/2015)

    Are you receiving a specific error message? I had this error today. The error message was along the lines "A network-related error or instance-specific error occurred while...

    March 27, 2015 at 12:35 pm

    #1787016

  • RE: How to give the customer to access SSAS Cube's?

    Koen Verbeeck (11/9/2012)

    SSAS works with Windows Authentication.

    You just need to add a role to the SSAS cube that gives the users (or their groups) read permissions on the cube.

    Is there...

    February 7, 2014 at 10:26 am

    #1687140

  • RE: Server side trace question

    I ran the following query to see if my select queries were trapped or not:

    select * from dbo.trace

    where textdata like '%SELECT * FROM %'

    TextData result just has:

    -- fn_trace_getinfo ...

    November 19, 2013 at 8:53 am

    #1667450

  • RE: Server side trace question

    Not sure if you were able to see my complete question.

    I listed out the events that I'm tracing and the filters that I've put.

    So, my question was --I ran long...

    November 19, 2013 at 8:49 am

    #1667446

  • RE: Monitoring question

    Keith Tate (11/6/2013)

    It really depends on what you consider to be "utilized". Does that mean resources, i.e. CPU, memory, I/O, etc? Does it mean user connections, batches/sec, etc? Does it...

    November 6, 2013 at 1:09 pm

    #1664555

  • RE: Delete statistics option is disabled when you try to delete statistics in sql server

    Smash125 (10/29/2013)

    Delete statistics option is disabled when you try to delete statistics in sql server 2008 r2. Please guide how to delete it

    I believe it's not possible through GUI....

    November 1, 2013 at 2:27 pm

    #1663605

  • RE: Extended Stored proc

    GilaMonster (11/1/2013)

    Extended stored procedures are written in C++, they do things that T-SQL can't do.

    Gotcha! Thanks Gail!

    Is there a way to see the script of extended stored procs?

    November 1, 2013 at 11:54 am

    #1663548

  • RE: TempDB question

    Jeff Moden (10/11/2013)

    sunny.tjk (10/11/2013)

    Does having multiple tempdb files on different drives help with contention?

    Yes... especially if they're on different drives.

    Thanks Jeff.

    October 14, 2013 at 2:56 pm

    #1658352

Viewing 15 posts - 1 through 15 (of 156 total)