There are some condition & times when SQL Server CPU utilization exceeds threshold value (ex 80% or more) and stay constant even till 100% for a undefined duration. A DBA do not get notified automatically about performance degrade until its reported by application team or service desk . This usually happens when all in sudden [...]
Archive for the ‘SQL DBA’ Category
How to Monitor SQL Server CPU Usage and get auto alerts
Posted: 28th December 2010 by Deepak in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: CPU 100%, cpu usage, CPU utilization, high cpu, monitor sql cpu, server utilization, SQL CPU, SQL CPU Utilization
9
SQL Server Query for Capacity Planning – SQL 2005 & 2008
Posted: 26th December 2010 by Deepak in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: capacity planning, database, database details, database information, database planning, database size, db structure, growth, space, sql build, trend
As a proactive DBA its one of responsibility to keep an eye on database’s growth and other file system changes for the databases hosted on SQL instance. However being busy on daily DBA tasks, its not always possible to prepare scripts or manually extract data from system for documentations & trend reporting purposes. I faced [...]
From SQLknowledge and Team, We wish you and your family a Merry Christmas! It was big fun on Christmas eve, we went to see a 90ft Christmas tree and gifts shopping.
Happy to join SQLKnowledge
Posted: 25th December 2010 by Shashikant in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: Happy to join SQLKnowledge
I have joined sqlknowledge and in addition to Deepak and other members, I will be writing about SQL troubleshooting, tips and tricks keep checking for more.. Merry Christmas
SQL 2011 Denali Basic Setup and Configurations
Posted: 22nd December 2010 by Deepak in SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: denali, installation, setup, sp_configure, sql 2011, sql dba, sql download
In continuation of my earlier post for Denali CTP1 launch, here are SQL Server 2011 setup screen prints. To begin with you can download installation media from Microsoft Link. Before you start installation, you must check system requirement and are as follows: System Requirements: Details Supported Operating Systems:Windows 7;Windows Server 2008 R2;Windows Server 2008 Service [...]
SQL Server Consolidation & Virtualization Practice..
Posted: 22nd December 2010 by Deepak in SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: DBA, hyper-v, license, sql, sql consolidation, sql cost cutting, sql p2v, upgrade, virtual server, virtualization, vmware
Consolidation by definition is the process of combining multiple SQL Server Databases & Servers running on different machines (could be geographically separated) onto a smaller number of more powerful machines in a central location. However in my opinion regarding SQL, its a process of getting organized, spending for what you need or use, and [...]
Scripts to prepare SQL Server Inventory
Posted: 21st December 2010 by Deepak in Scripts, SQL DBA, SQL Dev, UncategorizedTags: audit, authentication, collation, configuration, installation, license, MAP, page file, properties, service account, sql inventory
You never know, when you may need to rebuild a SQL sever with exact properties and configurations. Although there are dozen of 3rd party tools and software available in market to prepare enterprise level SQL Server inventory hosted in your environment like Microsoft Assessment and Planning (MAP), but keeping your own DBA script handy is [...]
Setup a low disk space alert for SQL Server drives
Posted: 21st December 2010 by Deepak in Scripts, SQL DBA, SQL Dev, UncategorizedTags: disk alert, disk space, low disk space, space, sp_OACreate, sp_OADestroy, sql drives
This is the pretty easy and clean script that you may use to check periodically your database server drive space. You can create a job to run on hourly basis to execute this code, along with a database mail code to send you alert if any of drive has less than 15% or 20% threshold [...]
What you ‘Currently’ don’t get with SQL Azure?
Posted: 21st December 2010 by Deepak in SQL DBA, UncategorizedTags: cloud, database, sql azure, sql business, sql cloud, sql dba, sql server, sql web
SQL Azure is cloud based relational database platform built on SQL Server technology; it allows storing structured, semi-structured and unstructured data over the cloud. Behind the scene databases are hosted on cluster SQL servers, and are load balanced plus replicated for scalability & high availability purposes. Each logical Server consists of one master and N [...]
Microsoft SQL Server 2005 Service Pack 4 RTM
Posted: 20th December 2010 by Deepak in SQL DBA, UncategorizedTags: DBA, download, service pack, SP4, sql, SQL Server 2005
Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available for download. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP4 . You can use these packages to upgrade any of the following SQL Server 2005 editions: Enterprise Enterprise Evaluation Developer [...]
