Post reply

Report server

  • November 2, 2011 at 1:12 pm

    #250233

    We would like to set up a new reporting server 2008.

    Any one has any recommendation for hardware specifications?

    Also is there a way I can find out for a existing server, the drives are physical drive or SAN drive by login to the server OS?

    Thanks

  • November 2, 2011 at 1:34 pm

    #1402398

    sqlfriends (11/2/2011)

    We would like to set up a new reporting server 2008.

    Any one has any recommendation for hardware specifications?

    Well.. That's kind of a loaded question 🙂 How many reports? How many people accessing it? Applications accessing it or just individuals? Will the reporting dbs be hosted on that server, or a separate one?

    Thanks,

    Jared

    Jared
    CE - Microsoft

  • November 2, 2011 at 1:47 pm

    #1402405

    As Jared said - we need a lot more info to answer that question. The reporting server needs to be built according to your reporting requirements.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • November 2, 2011 at 1:49 pm

    #1402406

    Thanks.

    I will do an estimate of the reports and find out.

    And also is there a way I can find out on an existing server, the drives are physical drive or SAN drive by login to the server OS?

  • November 2, 2011 at 2:10 pm

    #1402415

    I don't get it do you have access to the existing box? look at it in the back does it have fibre running to another server?

    Is it a windows OS? 2008, 2003?

    Anyway, you can go to computer management by getting to the run command type compmgmt.msc hit the enter key

    then go to the storage section and go to disk management.

    that will tell you the physical drives on the comp.

    Still rather know lots more?

    like what's the OS and it better be 64bit if you're using it for a lot of users if your using windows. SQL is a RAM hog and your limited to 4gb with 32bit

Viewing 5 posts - 1 through 4 (of 4 total)

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