Browse by Tags

• backups
• blocking
• blogs
• cache
• dbcc shrinkfile
• dmv
• execution plan
• FAQ
• high cpu
• huge
• indexes
• kba
• memory
• monitoring
• operating system
• performance
• query
• resources
• server
• sql server
• windows

SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?
25 April 08 01:30 AM | SQL Master | 2 Comments   

In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases Read More...

Filed under: sql server, cache, memory, indexes, databases, cpu, monitoring, operating system, huge, dbcc shrinkfile

High CPU issues that are specific to SQL Server 2000 installations and few with SQL 2005 too!
20 September 07 08:40 AM | SQL Master | 2 Comments   

Here comes another Frequently Asked Question (FAQ) on the forums and Frequently Posted Blog (FPB) here about high cpu issues on the SQL Server 2000 instances. Looking at high cpu spiks and performace issues is a common problem in all SQL Server installations, Read More...

Filed under: performance, sql server, query, blocking, databases, cpu, kba, execution plan, high cpu, resources, FAQ, blogs, backups

Using DMVs is it possible to identify whether CPU is hyper-threaded?
29 May 07 06:12 AM | SQL Master | (Comments Off)   

SYS.dm_os_sys_info DMV delivers most important information such as Operating System CPU tick count, hyperthread ratio, physical and virtual memory, as well as the worker and scheduler counts. From the derived values of this DMV if you observe hyperthread_ratio Read More...

Filed under: windows, cpu, server, dmv, databases