Forum Replies Created

Viewing 15 posts - 31 through 45 (of 69 total)

  • RE: MONITORING 60+ SQL SERVERS

    Grant Fritchey (6/19/2014)

    If you're going to set this up yourself, then I agree, Central Management Server is the way to go. There's plenty of documentation on that in the Books...

    June 21, 2014 at 8:04 am

    #1723764

  • RE: MONITORING 60+ SQL SERVERS

    eyespi20 (6/19/2014)

    There are some powershell scripts out there that can be used to do this kind of thing. They can be coded to produce very pretty excel spreadsheet type reports....

    June 21, 2014 at 8:03 am

    #1723763

  • RE: MONITORING 60+ SQL SERVERS

    GilaMonster (6/18/2014)

    For this you probably want to buy a 3rd party monitoring tool. It'll be the fastest and easiest. Is there budget?

    Grant Fritchey (6/18/2014)

    There are a ton of mechanisms built...

    June 18, 2014 at 11:00 pm

    #1723067

  • RE: Craeting DR in sql 2012 standarad version for priamry server 2005 enterprise sp4

    GilaMonster (11/10/2013)

    Possible, yes, but a really bad idea. Failover would work, providing you have no Enterprise-only features but you wouldn't be able to fail back.

    DR should be the same version,...

    November 11, 2013 at 5:41 am

    #1665438

  • RE: Suggest a port other then default

    Perry Whittle (11/6/2013)

    A port in the high end range is usually good, say 50000 - 60000.

    Where firewalls are in place and you wish to connect via the instance name you'll...

    November 7, 2013 at 12:10 am

    #1664635

  • RE: Proxy account for sql sever account

    dwilander (10/22/2013)

    Are you talking about application access to a database, an agent job, or ??? We generally create windows service accounts for both unless an application vendor has a...

    October 22, 2013 at 10:29 pm

    #1660790

  • RE: to know more about sql server in bulid default trace

    Grant Fritchey (10/7/2013)

    What Gail said.

    But, if you really want to avoid adding too much additional overhead to the system, then instead of a trace, I'd look at extended events. They're...

    October 10, 2013 at 12:39 am

    #1657386

  • RE: to know more about sql server in bulid default trace

    Grant Fritchey (10/5/2013)

    I would not suggest turning it off, no. You can add additional traces if you need them, but the default trace captures a basic set of information about...

    October 5, 2013 at 10:38 pm

    #1656142

  • RE: Memory uitilization

    GilaMonster (10/5/2013)

    Put the values that your client wants to see, it's not my report.

    I know its my report and client wants to know about total memory utilization by sql server.I...

    October 5, 2013 at 10:35 pm

    #1656141

  • RE: Memory uitilization

    GilaMonster (10/3/2013)

    Have a look at the sys.dm_os_memory* DMVs and the memory-related counters for SQL Server in perfmon.

    Hi gila thanks for your reply

    now i wanted to know whether i can...

    October 4, 2013 at 10:01 pm

    #1656078

  • RE: Basic difference between log shipping and mirroring

    GilaMonster (9/26/2013)

    anoop.mig29 (9/25/2013)

    but where are this log files kept

    Where ever you choose to put the log backups that you take. Mirroring doesn't use log backups, so where they go is...

    September 28, 2013 at 2:22 am

    #1654260

  • RE: Logshipping status report Throgh Mail

    MyDoggieJessie (3/1/2012)

    Doesn't the query I posted above give you the results you are looking for?

    I don't believe there is a way to access/schedule the SSRS report that's built in to...

    September 27, 2013 at 1:08 am

    #1653881

  • RE: Basic difference between log shipping and mirroring

    GilaMonster (9/25/2013)

    anoop.mig29 (9/25/2013)

    how is this carried out in mirroring , i mean where are this log files and how are they shipped

    Automatically. In mirroring the log records are sent across...

    September 25, 2013 at 10:42 pm

    #1653407

  • RE: Unable to send mail using database mail

    lshanahan (9/25/2013)

    You also want to check your anti-virus software and firewalls and be sure DatabaseMail is permitted.

    Carlaabanes (9/24/2013)

    what were the results of your initial investigation? have you checked the logs...

    September 25, 2013 at 11:57 am

    #1653297

  • RE: sql server using more memory issue

    GilaMonster (9/3/2013)

    Err... the second line of my post....

    As for why SQL's using the memory, because it can. Because it has not been told that it can't (via max server memory)....

    September 4, 2013 at 3:21 am

    #1647218

Viewing 15 posts - 31 through 45 (of 69 total)