Tag: performance

Pro Members SQL Server Standard Members

Some tips for using SQL Server 2019 file and filegroups

Some tips for using SQL Server 2019 file and filegroups Consider placing the tempdb log files on other physical disk arrays than those with the data files. Because logging is usually more write-intensive, it is important that the disk arrays containing the tempdb log files have sufficient disk I/O performance. Set the maximum size of the data and log files…....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Some useful tips for using XML in SQL Server 2019

Some useful tips for using XML in SQL Server 2019 Consider replacing OPENXML with the XML nodes() function. The nodes() function is useful when you want to shred an xml data type instance into relational data. The result of the nodes() function is a rowset that contains logical copies of the original XML instances. Use CROSS APPLY to get data…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Some tips to use System Monitor with SQL Server 2017

Some tips to use System Monitor with SQL Server 2017 System Monitor works on Windows operating systems and can be used to monitor an instance of SQL Server 2017. The difference between SQL Server Profiler and System Monitor is that SQL Server Profiler monitors Database Engine events, whereas System Monitor monitors resource usage associated with server processes. To start System…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

SQL Server 2017 Profiler Optimization Tips

SQL Server 2017 Profiler Optimization Tips SQL Server 2017 Profiler is a graphical user interface for monitoring an instance of the Database Engine or Analysis Services. SQL Server Profiler allows to capture and save data about each event to a file or table to analyze later. In this article, you can find some helpful tips to performance tune and optimize…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Useful SQL Server 2017 trace flags

Useful SQL Server 2017 trace flags There are 3 types of trace flags in SQL Server 2017: query trace flags global trace flags session trace flags Query trace flags are active for the context of a specific query. A global trace flag is enabled for the entire time SQL Server 2017 service is running and is applied to each of…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Tips for using full-text search in SQL Server 2017

Tips for using full-text search in SQL Server 2017 Make full-text index population during periods of low database access. Because full-text index population takes some time, these updates should be scheduled during CPU idle time and slow production periods. Reduce the full-text unique key size. To create a full-text index, the table to be indexed must have a unique index…....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Tips for using indexed views in SQL Server 2017

Tips for using indexed views in SQL Server 2017 Keep the indexes on the views as narrow as possible. Because each index takes up disk space try to minimize the index key’s size to avoid using superfluous disk space. This reduces the number of reads required to read the index and boost overall index performance. Try to create indexes on…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Some tips for using tempdb database in SQL Server 2017

Some tips for using tempdb database in SQL Server 2017 Set the reasonable size for the tempdb database and transaction log. First of all you should estimate how large your tempdb database will be. To estimate the reasonable database size, you should estimate the size of each table individually, add some additional space (10-20%) and then add the values obtained…....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Editorials

Basics: Your performance bottleneck may not be what you think it is

Been running into an interesting trend in working on different systems, looking for performance issues, finding things that need to be addressed.  Typically it all starts with a client that is confused about the performance they’re seeing after an upgrade that was supposed to fix everything automagically, but doesn’t seem to have accomplished that once completed. There are many, many […]

Pro Members SQL Server Standard Members

Tips for using SQL Server 2017 triggers

Tips for using SQL Server 2017 triggers Try to use CHECK constraints instead of triggers whenever possible. Constraints are much more efficient than triggers and can boost performance. Constraints are also more consistent and reliable in comparison with triggers, because you can make errors when you write your own code to perform the same actions as the constraints. So, you…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register