Professional Web Applications Themes

SQL 2K - FileGroups - Microsoft SQL / MS SQL Server

Hi RK, My advice to you is - Be patient. A large table (with large indexes) will take a lot of IO (and time) to tranfer. There is much more to it internally than simply transferring a file from disk to disk and EM does a lot of work 'behind the scenes'. If you had no problems with the small tables, you should have no problem with the big ones. Remember that locks are held during the transfer which might seem to 'hang' EM. Don't forcefully 'kill' the EM process even if it seems to 'hang' as this will cause ...

  1. #1

    Default Re: SQL 2K - FileGroups

    Hi RK,

    My advice to you is - Be patient.
    A large table (with large indexes) will take a lot of IO (and time) to
    tranfer.
    There is much more to it internally than simply transferring a file from
    disk to disk and EM does a lot of work 'behind the scenes'.
    If you had no problems with the small tables, you should have no problem
    with the big ones.
    Remember that locks are held during the transfer which might seem to 'hang'
    EM.
    Don't forcefully 'kill' the EM process even if it seems to 'hang' as this
    will cause the work to be undone.
    Make sure that the destination files and the transaction log files are large
    enough as auto filegrowths will make things even worse.

    HTH

    "RK" <com> wrote in message
    news:%phx.gbl... 


    Amy Guest

  2. #2

    Default Re: SQL 2K - FileGroups

    I suggest you move the table using TSQL instead of EM. EM sometimes does things in a very
    inefficient way...

    --
    Tibor Karaszi, SQL Server MVP
    Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver


    "RK" <com> wrote in message news:%phx.gbl... 


    Tibor Guest

  3. #3

    Default Re: SQL 2K - FileGroups

    Hello Amy & Greetings.

    I really appreciate your response to my query / posting. Indeed, I have been
    doing precisely that - killing forcefully the EM Process. One reason I did
    that was 'cos in the Task Manager window, under the SQL Server EM
    Application, it showed as 'Not Responding.' I am very pleased that your
    suggestion worked -- I now have the concerned table in a different
    FileGroup.

    Again, thanks for your help in this matter and appreciate it much.

    RK


    RK Guest

  4. #4

    Default Re: SQL 2K - FileGroups

    Hello All & Greetings.

    I have finally managed to now create filegroups and add some tables to these
    filegroups. For some tables,I am attempting to add to a filegroup though, I
    get the following WARNING Message.

    Warning:
    The following schema-bound objects will be modified:
    - View: indexes and schema binding will be removed.

    Can someone please explain the above and a workaround, please.

    Thank you all and appreciate much ... in advance!

    RK

    "RK" <com> wrote in message
    news:%phx.gbl... 


    RK Guest

  5. #5

    Default Re: SQL 2K - FileGroups

    Prety much what it says. But you do need to understand what schemabinding is to understand the error
    message. Read about CREATE VIEW and CREATE FUNCTION in Books Online, the WITH SCHEMABINDING option.

    --
    Tibor Karaszi, SQL Server MVP
    Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver


    "RK" <com> wrote in message news:phx.gbl... 
    >
    >[/ref]


    Tibor Guest

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139