Inside SQL Server 2005: Query Tuning and Optimization , any new …
Dec 13, 2014 · All replies 1 Sign in to vote hi, i have not read this book Inside SQL Server 2005: Query Tuning and Optimization,
Index Tuning : ReportServer DB - social.msdn.microsoft.com
Nov 2, 2007 · The reports seem to be a bit slow first run but speed up during the course of the day - the server generates about 1500 instances of reports each day (7 instances of …
process suspended status - social.msdn.microsoft.com
Nov 25, 2008 · CXPacket waits are parrallelism waits. You may need to adjust your maxdop setting or option it explicitly for the query having the problem. Sometimes parallelism can be …
DBCC SHRINKFILE EMPTYFILE Very Slow - social.msdn.microsoft.com
Dec 12, 2008 · There is plenty of free space in new files that we have created so this should not be an issue, also there is no activity on the database apart from the SQL DBCC command. …
What is CPU (Consumed) Wait Category?
May 26, 2012 · We have a new server with 2 E7 10 core CPU (totally 40 logical cpus including HT) in 2 NUMA nodes. The server is equipped with 128GB RAM, and we are running SQL …
performance counter registry hive consistency failed
Jan 2, 2015 · i tried to install sql server 2008 rs but i got this error, performance counter registry hive consistency failed
OLEDB Connection Working Very Slow. - social.msdn.microsoft.com
Aug 24, 2009 · We have recently Started using SSIS. Creating all the new packages from scratch which were in DTS on different server. The server which had DTS Packages are still running …
Index and table must user an equivalent partition function Errror
Feb 9, 2017 · I’m using SQL Server 2016 and I’m trying to solve an issue with a delete for a given date key value that takes forever, so I partitioned a table and tested it out with TRUNCATE …
SQL Azure - Slow query execution time in application, but not in …
Oct 31, 2015 · I'm trying to figure out some performance issues in my windows azure service, and noticed some particularly long times spend running queries in the database. In my cloud …
Want to collect performance data for analysis through out the …
Aug 5, 2013 · i am working on a VB.NET and making a performance ,monitoring,analysis and alerting tool for my client. Can you guys provide a complete script to fetch counter data using …