|
|
Browse by Tags
All Tags » performance » stats (RSS)
-
PARALLELISM is a close friend of DBA where you get to see it as a common occurence in the multi-processor server environment and during such performance issues you can also investigate whether a parallel plan is in use. For instance If a particular query is slow when it is using a parallel plan, you can try forcing a non-parallel plan by ...
-
Say you have two identical SQL Servers with similar databases in two different branches. Only the database sizes differ by about 20% and server machine are also identical. You will get a complaint that the performance of one is very very low compare to another, so how to find the issue to resolve?
If you have a test platform it is better to ...
-
Normally the backup and restore operation will be quick enough or depends upon the server configuration to complete. Say if you have started with a 2GB size of database and over the time as that database is updated, the amount of data that is included in differential backups increases.
This makes the backup slower to create and to restore. ...
-
Achieving the performance for slow running queries is not a rocket science to understand.
The database performance is dependant on implementing optimum database design with sensible hardware-based configuration and capacity planning. So how you can identify where the performance is degraded, say when you desing it is easy to identify the large ...
-
Every now and then I tend to see lot of questions such as ''We have a web application which interacts with SQL Server through Stored Procs. Every so often it seems the response time for an individual Stored Proc will go from a few seconds to a few minutes. What is best way to determine cause?
First thing to check is do you have ...
-
I have seen a common question across the forums & newsgroups that CPU is 100% when we are running a query on SQL Server. So it is important to understand whether CPU is affecting or is it a bad query that is affecting SQL Server performance in spite of high-spec hardware. I always recommend the article from SQLJunkies site about common ...
|
|
|