SEARCH RESULTS
 
Showing 1-10 of 16 records
 
Expand article

Check SQL Server database and log file size with this stored procedure

2008-05-13 12:06:09 by Heidi Sweeney in WhatIs: Enterprise IT tips and expert advice
 
...DBA responsibilities that you can accomplish easily with the stored procedure sp SDS. Not only will sp SDS determine "SQL Database Space," but it can also be used to monitor database growth, alert a DBA on data or log file growth, execute a transaction log backup and even provide a detailed breakdown at the file level so a DBA can then shrink...
 
Tags: sql server database, sds, sql database space, log file growth, sds determine, monitor database growth, dba, transaction log backup, accomplish easily
 
 
 
 
Expand article

Monitor SQL Server disk I/O with PerfMon counters

2008-04-04 10:20:15 by Heidi Sweeney in WhatIs: Enterprise IT tips and expert advice
 
...DBA, you need to understand the I/O of your SQL Server disk subsystem. In part 3 of this screencast series, "PerfMon counters for the SQL Server DBA," SQL Server MVP Kevin Kline explains how to track I/O in your direct-attached storage disks (DASD). Get optimal throughput values to keep an eye on when using Performance Monitor counters for...
 
Tags: sql server dba, dba, perfmon counters, physical disk reads, performance monitor counters, optimal throughput values, disk queue length, screencast series, storage disks
 
 
 
 
Expand article

How to Do Database Logging/Monitoring "Right"?

2007-12-13 11:26:00 by Dr Anton Chuvakin in Anton Chuvakin Blog -
 
...DBA monitoring No agents No database configuration changes Extra device needs to be purchased, deployed and managed Doesn't work with encryption No local access monitoring Collect and analyze database logs No extra $$$ - use your existing logging tool Can user review activity across log sources, from databases to servers Satisfies...
 
Tags: database, analyze database logs, database logs, database log review, database performance impact, database configuration, performance impact, database log management, log management
 
 
 
 
Expand article

Geeks.com customer credit card data compromised

The Article has images
2008-01-07 21:34:58 by Evan Francen in The Breach Blog
...dba Geeks.com ("Genica") recently discovered on December 5, 2007 that customer information, including Visa credit card information, may have been compromised In particular, it is possible that an unauthorized person may be in possession of your name, address, telephone number, email address, credit card number, expiration date, and card...
 
Tags: credit, credit card, card, geeks, credit reports, report credit, breach description, breach, apparent breach
 
 
 
 
Expand article

SQL Server PerfMon counters for tracking Windows memory

2008-03-06 11:26:32 by Heidi Sweeney in WhatIs: Enterprise IT tips and expert advice
 
In part 1 of this series on "PerfMon counters for the SQL Server DBA," SQL Server MVP Kevin Kline walks you through significant PerfMon counters for tracking Windows memory. In this screencast, you'll learn the maximum numbers to watch for when using PerfMon counters as a method to avoid memory pressure in your SQL Server system
 
Tags: perfmon counters, significant perfmon counters, windows memory, avoid memory pressure, sql server dba, sql server system, maximum, series, screencast
 
 
 
 
Expand article

SQL Server PerfMon counters for Windows operating system (OS)

2008-03-18 10:46:08 by Heidi Sweeney in WhatIs: Enterprise IT tips and expert advice
 
SQL Server PerfMon counters can help troubleshoot and even avoid bottlenecks on your Windows operating system. In part 2 of this screencast series on "PerfMon counters for the SQL Server DBA," SQL Server MVP Kevin Kline walks you through best practices and maximum values to watch for when using counters to monitor OS performance
 
Tags: counters, perfmon counters, sql server dba, system, windows, maximum values, screencast series, avoid bottlenecks, monitor
 
 
 
 
Expand article

Track changes to SQL Server 2000 and 2005 with one simple utility

2008-04-03 11:21:30 by Heidi Sweeney in WhatIs: Enterprise IT tips and expert advice
 
...DBA, you need to be aware of what's happening within your SQL Servers. This includes new objects, logins and even databases. But if you have dozens of SQL Servers -- both 2000 and 2005 models -- and permissions are shared, you'll have to go beyond the limits of triggers. SQL Server expert Michelle Gutzait shares some handy scripts in a...
 
Tags: sql servers, handy scripts, utility, system tables, email alerts, permissions, monitor, triggers, limits
 
 
 
 
Expand article

SQL Server PerfMon counters for access methods and buffer manager

2008-04-29 13:18:07 by Heidi Sweeney in WhatIs: Enterprise IT tips and expert advice
 
...DBA," SQL Server MVP Kevin Kline focuses specifically on SQL Server counters. Kline shares best practices for using access method counters to watch for IO intensive operations, such as full table or clustered index scans and page splits. You'll also learn why it's important to monitor the buffer manager in SQL Server, that is, keep an eye on...
 
Tags: sql server, sql server counters, buffer manager, buffer, sql server dba, perfmon counters, quickly pages age, access method counters, lazy writer
 
 
 
 
Expand article

Your Turn At The Bar Again? Security Costs in a Pay Per Drink Cloud

The Article has images
2008-05-01 20:55:26 by Craig Balding in Cloud Security
...DBA and Simon the Security Dude Oscar : Hey Simon, your Security Agents are killing system performance again. Anna in accounts called up to say they cant do the Quarterly close, the jobs are getting killed before they finish Simon : Hi Simon, I understand but we cant just disable all the security Oscar : Well, we need to do something if we...
 
Tags: security costs, costs, runtime security costs, security runtime costs, security, security tool, security tool inefficiency, security tools plays, plays