Michael Otey


Michael Otey, Senior Contributing Editor for Windows IT Pro and SQL Server Pro, is president of TECA, a software-development and consulting company in Portland, Oregon. Michael has covered the topic of virtualization extensively for Windows IT Pro, having written several features articles showing how to take advantage of virtualization in the enterprise as well as reviewing all of the major virtualization products. Follow Michael on Google+ and Twitter.

Writing Perfmon data to SQL Server

Q: I’m trying to get Perfmon to write performance counter data to SQL Server. In Perfmon I’ve created a Data Collector and I set the Log format to SQL. I have also created a data source using the SQL Server Native driver but when I try to start Perfmon I get the error Call to SQLAllocConnect failed with %1.

A: I’ve found that you cannot use the SQL Server Native Client to log data to SQL Server from Perfmon. I have only had success when the data source that I created used the ODBC driver like you can see in Figure 1.

SQL Select: FAQs about SQL Server 2014 2
Answers to your most frequently asked questions about SQL Server 2014
Dealing with an Inherited SQL Server
Get a quick must-do checklist for dealing with an inherited SQL Server system
FAQ: Missing SSMS IntelliSense Changes
See what to do when IntelliSense doesn't recognize your new database objects
Moving SQL Server to a Virtual Platform
Learn about some of the main factors that impact SQL Server performance in a VM
Where do I find SQL Server Management Studio?
Find the executable for SSMS
Scaling SQL Server With No Hardware
Learn about SQL Server's core database performance factors
The Essential Guide the SQL Server 2014: Backup Enhancements
Learn about the backup enhancements in SQL Server 2014
Hit Your SQL Server Performance Goals
Benchmarking enables you to stay on top of your SQL Server performance goals
Q & A: Restore Missing SQL Server Performance Counters
See how to restore missing SQL Server performance counters
The Essential Guide to SQL Server 2014: The Resource Governor
Learn about the new IO limiting capabilities of SQL Server 2014's Resource Governor
Q & A: How can I recover my sa Password? 2
See how you can reset a lost sa password
The Essential Guide to SQL Server 2014 Series: Buffer Pool Extensions 1
Learn where to use SQL Server 2014's Buffer Pool Extensions
SQL Select: 8 Great New Features in SQL Server 2016 1
Learn about the top eight new features coming in SQL Server 2016

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
Sep 29, 2015

Data Breaches and Insider Threats

I’ll sound a bit like Captain Obvious for bringing this up, but it’s important to remember that security encompasses a lot more than protecting sensitive data from the specter of outsider threats like hackers. Properly implemented security policies also account for threat-models that include insiders – or people within your organization....More
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups 1

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular execution of T-Log backups on Full (and Bulk-Logged) Recovery databases helps keep thing “fit and trim”. Most of the time, setting up a Notification for when T-Log Backup Jobs fail is enough to let you know when something goes wrong....More
Sep 1, 2015

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks 3

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')         DROP TABLE TableToDrop; GO Neither is this: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TableToDrop')         DROP TABLE TableToDrop; GO Yet, I see both of those used all of the time – over and over again. Even though it’s 2015.  ...More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×