Browse by Tags

• allocation
• bcp
• bulk insert
• bulk-logged
• cache
• cpu
• data
• deadlock
• destination
• disks
• dmv
• extent
• file
• fragmentation
• import
• indexes
• insert
• object
• performance
• source
• SQL Server
• table
• tuning
• type
• wait

• DBCC EXTENTINFO - unused pages in these extents (undocumented)

  When it comes to resolving table fragmentation, the basic checkout you perform is to run DBCC INDEXDEFRAG or even run DBCC DBREINDEX statements. As per the default configuraiton SQL Database Engine allocates a new extent to an allocation unit only when Read More... Posted Tuesday, September 04, 2007 10:45 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, indexes, fragmentation, table, deadlock, i/o, insert, data, allocation, extent

• ASYNC_NETWORK_IO: query is slow

  When you run normal SELECT statement from the Activity Monitor, the session has a status of "suspended", a command of "SELECT" and a wait type of "ASYNC_NETWORK_IO". What do you expect to the see the results and within the column status, we will see quite Read More... Posted Wednesday, August 29, 2007 8:00 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, i/o, disks, tuning, type, wait, object

• Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in BCP data-file

  When you use BCP then you would definelty get to see this error "Unexpected EOF encountered in BCP data-file". Not only that I have seen this as one of the frequently asked questions (FAQs) and for a moment you might be thinking why there is an end of Read More... Posted Wednesday, August 29, 2007 1:10 AM from SSQA.net | (Comments Off) Filed under: SQL Server, i/o, bulk-logged, destination, bulk insert, source, bcp, file, import

• List of CPU based DMVs in SQL Server 2005 - best used for hardware analysis

  Dynamic Management Views (DMV) are very useful to get server state information to monitor the status, but not always you have to still continue in monitoring using SYSMON & PROFILER that are available by default with SQL installation. The engine within Read More... Posted Monday, August 06, 2007 5:32 AM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, cache, cpu, dmv, i/o