Forum Replies Created

Viewing 15 posts - 16 through 30 (of 241 total)

  • RE: Full Recovery DB

    select name,recovery_model_desc from master.sys.databases

  • RE: Full Recovery DB


    declare
    @db sysname ,
    @srv varchar(15),
    @inst varchar(15),
    @msd datetime,
    @MFD datetime,
    @bl varchar(260),
    @ty char(1),
    @rm varchar(255)

  • RE: Full Recovery DB

    there are many ways to do that, here are some of them

    1) you can use batch/cmd file to run query to find out
    2) you can use powershell...

  • RE: 014 insufficient permission

    I was more interested in tokens. you need to find wmi property token for ip and or machine name.  if you are using wmi 

    may be this help 

  • RE: 014 insufficient permission

    is this wmi alert?, please post the code for alert

  • RE: Limit Size of Tables

    what my friend you need is Policy Based Management - go crazy (test test test and test) 
    you can create readonly filegroup and move table to RO_filegroup..  just an idea.. 

  • RE: System Memory

    spending $$ is no issue, the question is what if adding memory to OS does not satisfy Symantec's urge to use page file

  • RE: System Memory

    I am sure database files are excluded but I will confirm,  the biggest database is about 900gb, I will also see what I can find from Symantec,
     any advise/guide lines to...

  • RE: System Memory

    Thanks Guys,
    Answering my own question,, 

    process explorer

  • RE: System Memory

    there are no other applications on the box, other than symantec and vmware/backup tools for which I am sure 6GB is more then enough, there is no SSRS/SSAS on the...

  • RE: SQL Account

    you can create a script to create your logins and permission and save them at network location, Just run the script after the install that is  the automation level you...

  • RE: Monitoring Resource Governor checking if your pools are not max out on CPU

    yep..  figure out the rest

    USE [msdb]
    GO
    EXEC msdb.dbo.sp_add_alert @name=N'resource_pool_CPU',
            @enabled=1,
            @delay_between_responses=0,
            @include_event_description_in=0,
            @performance_condition=N'Resource Pool Stats|CPU usage %||>|90',
            @job_id=N'00000000-0000-0000-0000-000000000000'
    GO

  • RE: SQL Account

    please explain 'automating service account'

  • RE: sql job taking more time

    check what else is running when job run,  check job schedule conflict, there might be other jobs/process run that might effect the job duration.

  • RE: SQL Account

    keep in mind you need to setup mail profile as well for this thing to work..

Viewing 15 posts - 16 through 30 (of 241 total)