http://mvmnoushad.blogspot.com/2010/01/difference-betwwen-ado-vs-odbc-vs-ole.htmlApplication --> ADO --> ODBC --> DatabaseUsing this kind of scheme lets you change one of the layers without changing the others (usually). ODBC is older than OLEDB but is an

<br />http://www.mssqltips.com/tip.asp?tip=1515<br /> <br />Problem<br />In a previous tip, "Setting up Performance Monitor to always collect performance statistics"I wrote about how to collect performance monitor data,  but once youhave the data t

<br />http://www.mssqltips.com/tip.asp?tip=1475<br />Problem<br />Very often when performance problems arisethere are a few tools that I always first look at using to helptroubleshoot SQL Server issues. One of these tools is PerformanceMonitor.  Th

<br />Step1 : Open Performance monitor <br /><br /><br />On the Start menu, point to Programs, point to Administrative Tools, and then click Performance Monitor.<br /> <br />Step2 : Add new data collector set<br /> <br /><br /> <br /><br /><br />St

<br />http://www.sqllion.com/2009/05/monitoring-tempdb-in-sql-server-2005/<br /> <br />As the tempdb database is the common globalresource for all the operations going on in SQL Server, so the DBA hasto be bit cautious about the use of it. Because an

<br />http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/<br /> <br />USE msdb<br />GO<br />EXEC sp_send_dbmail @profile_name='PinalProfile',<br />@recipients='test@Example.com',<br />@subject='Te

<br />http://www.mssqltips.com/tip.asp?tip=1212<br />Problem<br />Just about all SQL Server performancerelated tips talk about using data from Performance Monitor and datafrom SQL Profiler.  The big draw back has always been that they are twototall

<br />http://www.mssqltips.com/tip.asp?tip=1035<br />Problem<br />When troubleshooting a SQL Serverperformance problem, one of the tools to use is Profiler. This toolallows you to collect metrics on statements that are run on your SQLServer for ana

http://glennberrysqlperformance.spaces.live.com/?_c11_BlogPart_BlogPart=blogview&_c=BlogPart&partqs=cat%3dSQL%2520Server%252020052010/10/20SQL Server 2005 Diagnostic Information QueriesIthas been a while since I posted the SQL Server 2005 version of this

<br />http://glennberrysqlperformance.spaces.live.com/?_c11_BlogPart_BlogPart=blogview&_c=BlogPart&partqs=cat%3dSQL%2520Server%25202008%2520R2<br />What is usingall of my memory in SQL Server?  If you ever believe that you areseeing signs of memory pre