Post reply

Sqlserver2005 Space limit

  • September 11, 2008 at 1:16 am

    #190746

    hi,

    How to check that the user has exceeded the maximum space limit in sqlserver2005?

    Thanks in Advance,

    With Regards,

    Poornima

  • September 11, 2008 at 3:43 am

    #870182

    There's no such thing in SQL Server as a maximum space limit for users.

    Could you explain a bit more what you need.

    Do you want to limit the amount of data a user stores in a database or what else?

    [font="Verdana"]Markus Bohse[/font]

  • September 11, 2008 at 4:29 am

    #870193

    Hi,

    Thanks for ur reply.Now only i got my clear details tat satisfy my need

    i)SqlServer2005 Connection quota limit

    ii)At a time how many connection can be established in the server

    Please tell me the answer this.

    Thanks in Advance,

    With Best regards,

    Poornima

  • September 11, 2008 at 4:48 am

    #870209

    SQL doesn't have any quotas. The max number of concurrent connections possible to an instance is 32767, but you'll need one seriously powerful server (with tonnes of memory) to handle that.

    Can you explain a bit more what you're after?

    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 11, 2008 at 5:01 am

    #870216

    Hi GilaMonster,

    Thanks for ur reply.

    U have mentioned tat, 'At a time 32767 connection is possible'.

    Really it helps me a lot.

    Could u tell me totally how many connection possible in SqlServer?

    Thanks in Advance,

    With Best Regards,

    Poornima

  • September 11, 2008 at 5:16 am

    #870226

    poornima.s_pdi (9/11/2008)

    Could u tell me totally how many connection possible in SqlServer?

    I just did. 32767 is the maximum possible simultaneous connections to a SQL Server instance. The number a server will be able to handle without getting overloaded depends on the server.

    What are you trying to achieve?

    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 11, 2008 at 5:24 am

    #870232

    Hi GilaMonster,

    If we take Sqlserver2005DeveloperEdition,

    Connection limit->20

    Like that any connection Limit is there in SqlServer2005.

    This is my need.Its very urgent....

    Help me Plz.

    Thanks in Advance

    Poornima

  • September 11, 2008 at 6:20 am

    #870253

    For the third time, the maximum limit to concurrent connections in SQL Server 2005 is 32767.

    The value that you see under the server properties - connections can be set by you to any value up to and including that value.

    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 11, 2008 at 6:32 am

    #870261

    Hi GilaMonster,

    Thank u.

    I will discuss about this with my TM and TL...and let u know if there is any further details we want...

    With Regards,

    Poornima

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply