SQL Server Knowledge by Batuhan YILDIZ

Notes From The Field Experiences and Useful Scripts - By Microsoft Premier Field Engineer

Browse by Tags

Tagged Content List
  • Blog Post: What size is suitable as an Initial Size for tempdb system database?

    The size and physical placement of the tempdb database can affect the performance of a system. For example, if the size that is defined for tempdb is too small, part of the system-processing load may be taken up with auto-growing tempdb to the size required to support the workload every time you restart...
  • Blog Post: Which one is better? PERSISTED Column or XML Indexes?

    I had a chance to work on the XML area. The customer had a performance issue with some queries which were related to XML data. The customer was using a banking application called TEMENOS T24 on Microsoft SQL Server. The tables in the databases have just 2 columns RECID and XMLRECORD which has all the...
  • Blog Post: How to find busy tables in SQL Server?

    There is a performance issue on the system. You check the sys.dm_os_wait_stats and you see that PAGEIOLATCH wait type is at the top. You know that it is related to disk performance. It may be because of the high IO issue or disk related issue itself. You collect the performance counters “Avg. disk sec...
  • Blog Post: TOP N Biggest Tables in every database

    Sometime it may be useful to find all the big tables in all databases. There may be performance issue on the system and it can be necessary to move some tables to another disk to decrease the disk latency. So additional File Groups and Files can be created and some of those big tables can be moved to...
  • Blog Post: TSQL for database size, data and log available size

    What are our databases sizes in SQL Server? How much space is Available? How can I prevent the automatic auto growth of data and log files? How can I be notified if there is not enough space in the log file? It will be really good to consolidate all the SQL servers with their databases with the space...
Page 1 of 1 (5 items)