Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Administration Rss

Search for any content tagged administration

<< Newer    Items 41 to 60 of 805    Older >>
 

Evaluating Policies on Multiple SQL Server Instances using Central Management Server

you have created a SQL Server Policy to check database recovery models. Now you need to check the databases on all of your SQL Server instances. In this tip we will show how you can evaluate a SQL Server policy against multiple instances.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,140 reads

SQLServerCentral Runs sp_Blitz - Performance Part 1

The third article that examines the output of the sp_Blitz script&trade; run against SQLServerCentral's database servers.  Read more...
By Steve Jones 2013/01/22 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 7,922 reads

SQLServerCentral Runs sp_Blitz - Reliability

The second article that examines the output of the sp_Blitz script&trade; run against SQLServerCentral's database servers.  Read more...
By Steve Jones 2013/01/15 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 4,974 reads

SQLServerCentral Runs sp_Blitz - Security

A series that looks at the SQLServerCentral database servers using the Brent Ozar Unlimited sp_blitz script. Read about what we learned.  Read more...
By Steve Jones 2013/01/10 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 8,797 reads

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.   Read more...
By Andy Warren 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,496 reads

What Counts for a DBA: Being Replaceable

Louis Davidson describes why all DBAs should strive to be replaceable, and what that really means.  Read more...
By Louis Davidson (@drsql) 2012/12/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 219 reads

Steps to add Log Shipping monitor into an existing SQL Server

I have a requirement to add the Log Shipping Monitor for an existing installation. I have heard you can only complete this by rebuilding the Log Shipping infrastructure. Is that true? Are there any other options? In this tip I will explain how we can add the Log Shipping monitor to a SQL Server 2005, 2008, 2008 R2 or 2012 environment without rebuilding the Log Shipping installation.  Read more...
By Additional Articles 2012/12/05 | Source: MSSQLTips.com | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 1,874 reads

Has tempdb grown since the last restart?

Check tempdb to see if it has been autogrown since the last restart. If it has, there may be an opportunity to improve server performance.  Read more...
By Orlando Colamatteo 2012/11/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,985 reads

Viewing VMware Counters in PerfMon for SQL Server

I want to ensure that my SQL Server on a VMware Guest OS is getting the resources it should. This would go a long way towards helping isolate the performance problems we're experiencing. However, our system administrators won't give us access to VirtualCenter or any of the tools they use. Is there anything I can do? Check out this tip to learn more.  Read more...
By Additional Articles 2012/11/12 | Source: MSSQLTips.com | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 2,522 reads

Manage By Delegation

There always seem to be more and more instances to manage, but not more and more staff. Steve Jones talks about the key to good management being delegation of the work.  Read more...
By Steve Jones 2012/10/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 120 reads

Check SQL Server Virtual Log Files Using PowerShell

In a previous tip on Monitor Your SQL Server Virtual Log Files with Policy Based Management, we have seen how we can use Policy Based Management to monitor the number of virtual log files (VLFs) in our SQL Server databases. However, even with that most of the solutions I see online involve the creation of temporary tables and/or a combination of using cursors to get the total number of VLFs in a transaction log file. Is there a much easier solution?   Read more...
By Additional Articles 2012/10/11 | Source: MSSQLTips.com | Category: administration
Rating:  Rate this |   Briefcase | 2,862 reads

Never update systems tables directly - a study in Agent job scheduling

It is often recommended that system tables should not be updated directly. Presenting a case in point built around nightly job configuration in order to demonstrate the possible issues with updating system tables directly.  Read more...
By Nakul Vachhrajani 2012/09/17 | Source: SQLServerCentral.com | Category: sql server agent
Rating: |  Discuss |   Briefcase | 4,280 reads

The DBA Database

One very handy item Steve Jones found as a DBA was a DBA only database on each instance. Today he asks you if you have one and if not, why not. There are good reasons to have one, and security is usually not a problem.  Read more...
By Steve Jones 2012/07/31 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 412 reads

Comparing Two Recordsets Using Powershell

How can you quickly and easily compare recordsets from different instances? This article will show you a quick way to do this with PowerShell.  Read more...
By Tom Powell 2012/07/13 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,025 reads

Indexes, Indexes, Indexes

This article has a description of an index utilization tool that Ron Johnson uses to analyze the effectiveness and use of indexes in a system.  Read more...
By Ron Johnson 2012/07/04 (first published: 2011/07/05) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 18,815 reads

Instant File Initialization and restores

Instant file initialization also has its advantages when you restore a SQLServer database. This article will show you why.  Read more...
By Johan Bijnens 2012/05/21 | Source: SQLServerCentral.com | Category: backup / recovery
Rating: |  Discuss |   Briefcase | 4,066 reads

Perform Routine Server Checks Using PowerShell

Database administrators tend to perform a lot of routine checks, referred to as sanity checks, on a daily, weekly, and monthly basis. Rob Gravelle shows you how to write some PowerShell scripts to automate a couple of fairly common sanity checks.  Read more...
By Additional Articles 2012/05/21 | Source: Database Journal | Category: powershell
Rating:  Rate this |   Briefcase | 3,556 reads

Snapshot Isolation Level in SQL Server - What, Why and How - Part 1

Snapshot isolation levels improve performance but there are some things to take into consideration when using this feature. Arshad Ali discusses what snapshot isolation levels are, their variants, and why and when we should use them.  Read more...
By Additional Articles 2012/05/14 | Source: Database Journal | Category: administration
Rating:  Rate this |   Briefcase | 3,566 reads

The Real World: Fragmented Disk and High PAGEIOLATCH Waits

This article decribes how defragementing a 900 GB drive assisted in addressing major performance issues on a reporting server.  Read more...
By Kenneth Igiri 2012/04/20 | Source: SQLServerCentral.com | Category: fragmentation
Rating: |  Discuss |   Briefcase | 6,268 reads

Understanding Retention Periods for SQL Server Transactional Replication

I have transactional replication configured in production. I have heard about the replication retention period, but what is the significance of this. Would there be any impact to my replication configuration if data is not synchronized with the subscriptions within the retention period?  Read more...
By Additional Articles 2012/04/17 | Source: MSSQLTips.com | Category: replication
Rating:  Rate this |   Briefcase | 2,403 reads
<< Newer    Items 41 to 60 of 805    Older >>