Learn the tricks to get Perfmon to write performance counter 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.
from SQL Server Pro http://ift.tt/1kCjeYg
Nenhum comentário:
Postar um comentário
Leave your comment here!