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 the instance…

2

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…

0

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/Read” and…

3

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…

1

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…

2