Forum Replies Created

Viewing 15 posts - 571 through 585 (of 1,518 total)

  • RE: Memory pressure when calling a C# assembly

    Paul White (9/9/2009)

    Marios Philippopoulos (9/9/2009)

    I have had the same problem in the past (on 32-bit environment).

    I used the -g startup parameter (I specified it as -g384), and the problem...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    September 9, 2009 at 8:11 am

    #1051140

  • RE: Memory pressure when calling a C# assembly

    I have had the same problem in the past (on 32-bit environment).

    I used the -g startup parameter (I specified it as -g384), and the problem went away.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    September 9, 2009 at 7:23 am

    #1051072

  • RE: Linked Servers vs. Integration Services - Pros and Cons

    Elliott W (8/27/2009)

    I think I have your answer:

    http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-ssis-tuning-the-dataflow-task/

    Use a SQL Select Statement to Retrieve Data From a View

    Avoid using the Table or view access mode in the OLE DB Source...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 27, 2009 at 11:26 am

    #1045723

  • RE: Linked Servers vs. Integration Services - Pros and Cons

    Elliott W (8/27/2009)

    I can't remember for sure, I know there is a reason, but I can't remember why. Sorry man..

    CEWII

    No worries, I'd like to learn more about the internals...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 27, 2009 at 7:59 am

    #1045546

  • RE: Linked Servers vs. Integration Services - Pros and Cons

    The performance issue is fixed.

    The package has gone from running for over 3 hrs to 10 seconds!!

    The change you ask?

    In the OLEDB Source of my data-flow component I...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 26, 2009 at 4:45 pm

    #1045261

  • RE: Linked Servers vs. Integration Services - Pros and Cons

    gah (8/14/2009)

    have you any "WHERE" clauses in your SELECT...

    Yes, we have a WHERE clause in the OPENQUERY SELECT.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 17, 2009 at 1:59 pm

    #1040465

  • RE: Linked Servers vs. Integration Services - Pros and Cons

    Gkhadka (8/14/2009)

    Marios, I think something is going wrong @ ur SSIS. I have a ssis package that loads over a 8 millions rows in less then 15 mins, to be...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 14, 2009 at 3:12 pm

    #1039727

  • RE: Linked Servers vs. Integration Services - Pros and Cons

    gah (8/14/2009)

    what response times do you get if you use OPENQUERY against the LinkedServer?

    are you filtering on any records in the source table?

    Thanks for the suggestion, actually this is in...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 14, 2009 at 3:10 pm

    #1039724

  • RE: Linked Servers vs. Integration Services - Pros and Cons

    Elliott W (8/14/2009)

    That is shockingly bad performance. The other thought I had is what ELSE is going on on the source and destination servers at the same time, could...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 14, 2009 at 2:18 pm

    #1039700

  • RE: Linked Servers vs. Integration Services - Pros and Cons

    I just noticed that I'm using the "Table or View" access mode in the OLEDB Source Adapter. According to this link this is very bad for performance:

    http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-ssis-tuning-the-dataflow-task/

    Use a SQL Select...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 14, 2009 at 1:53 pm

    #1039680

  • RE: Linked Servers vs. Integration Services - Pros and Cons

    Elliott W (8/14/2009)

    Three thoughts:

    1. Is the destination table empty at the beginning of the load? I seem to remeber being told that this can prevent the fast load option...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 14, 2009 at 1:37 pm

    #1039664

  • RE: Linked Servers vs. Integration Services - Pros and Cons

    Hey guys, good point on caching data locally at set intervals and using local queries during the day (as opposed to linked servers).

    At this point of the discussion I have...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 14, 2009 at 10:46 am

    #1039545

  • RE: Linked Servers vs. Integration Services - Pros and Cons

    I'm not using ORACLE, but the link contained interesting info all the same.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 13, 2009 at 1:26 pm

    #1038961

  • RE: Linked Servers vs. Integration Services - Pros and Cons

    This link looks interesting:

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ce92ab37-b051-4f9e-9072-9fce685c83c0

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 13, 2009 at 12:31 pm

    #1038917

  • RE: Linked Servers vs. Integration Services - Pros and Cons

    Elliott W (8/12/2009)

    I don't know of any tools, but the first problem is figuring out what is using linked servers, you can do a search of the syscomments using the...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 13, 2009 at 12:03 pm

    #1038897

Viewing 15 posts - 571 through 585 (of 1,518 total)