Tag Archives: Performance Tuning

DBCC Cleaning CACHE – Memory

DBCC Cleaning CACHE – Memory I wanted to write this blog for quite some time, here you go, as you know at sql everything is on memory, memory information retrieve quickly compare to Disk. So if things are not in … Continue reading

Posted in Memory, Performance Tuning, Troubleshooting | Tagged , , , , | Leave a comment

Denali — Day 5: Column-store indexes (aka Project Apollo)

Denali – Day 5: Column-store indexes (aka Project Apollo)   There is another great achievement for Denali, especially for Data warehouse, where data is static and very huge – READONLY, and user always require data to be retrieved quickly as … Continue reading

Posted in Denali, Index, Performance Tuning | Tagged , , | Leave a comment

Performance Tunning Part 2

After checking on the net found that there are lots of lots of good stuff (queries) already describe the performance related information, so I would like the share and refer some of the very good site. I have already blog … Continue reading

Posted in DMV, Lock/Blocking, Performance Tuning, Whitepapers | Tagged , , | Leave a comment

performance Tunning continue…

We have discussed performance tunning part1, continue on that… Resource is the base for performance, if you don’t have sufficient space the optimum query/system may also not work efficiently. Latch: Latch is for physical synchronization, like while >> accessing pages … Continue reading

Posted in Performance Tuning | Tagged | Leave a comment

Miscellaneous Info

Some undocumented and important stuff   DMV: dbcc showcontig – index_physical_stats will scan complete index pages even if you use where clause Backup : uses 960k speed can reduce to 64k. Virtual File Space … for 32 bit system. Default big … Continue reading

Posted in DMV, Experts, General, Others, Tool | Tagged , , | Leave a comment

Lock Info

Lock: As we have discussed about introduction locks here(in our earlier blog). Here we will discuss how to trouble shoot locking. Locking is good to maintain the consistency of our data. Means when someone is update our data no one … Continue reading

Posted in DeadLock, Lock/Blocking, Performance Tuning | Tagged | Leave a comment

Troubleshooting Performance -1

Whenever you get a call from user that they are facing any performance issue what would you do. As I blog earlier on this, we should follow the top down approach where we need to see the scenario from bigger … Continue reading

Posted in Performance Tuning, Webcast | Tagged | Leave a comment

Torn page detection vs Page Checksum

TornPage Detection: Up to sql server 2000, for data corruption process is called torn page detection, this option is default on. The data page is of size 8k and  combination of 8 pages is called extent. where as hardware storage is stored in … Continue reading

Posted in Basic, Computers and Internet, What I learned today | Tagged , , | 2 Comments

NOLOCK – truth

With the NOLOCK hint (or setting the isolation level of the session to READ UNCOMMITTED) you tell SQL Server that you don’t expect consistency, so there are no guarantees. Bear in mind though that “inconsistent data” does not only mean … Continue reading

Posted in Lock/Blocking, What I learned today | Tagged , | Leave a comment

Lock page in memory

When you configure the memory and on your system if other applications are also present, in such cases de-allocation of memory may impact huge performance issue. so lock page memory is useful here as to prevent/reserve the memory for Sql … Continue reading

Posted in Memory, Others, Performance Tuning, What I learned today | Tagged , | Leave a comment