SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
»
All Tags
»
performance
(
RSS
)
Sign in
|
Help
MSMVPS.COM
The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.
Home
Blogs
Media
Browse by Tags
Blogs
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Home
About
Contact
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go
Recent Posts
How SQL Server 2008 can help to build fast track data warehouse?
SQL Server database design goals: Memory, Disk and I/O - maximize the scalability with monitoring
SQL Server 2005 and SQL Server 2008 reports 701 errors with large batch sizes
Microsoft Advisory Services Engagement Scenario - SQL Server Performance
Hyper-V and SQL Server Consolidation - whitepaper!
Tags
2005
2008
best practice
best practices
community
conference
database
databases
dba
dmv
download
error
indexes
kba
microsoft
performance
query
replication
security
sql server
ssis
ssms
tsql
T-SQL
webcast
View more
News
Archives
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
Blog Archive List
November 2009 (2)
October 2009 (6)
September 2009 (4)
August 2009 (17)
July 2009 (8)
June 2009 (7)
May 2009 (17)
April 2009 (23)
March 2009 (13)
February 2009 (21)
January 2009 (25)
December 2008 (24)
November 2008 (20)
October 2008 (14)
September 2008 (26)
August 2008 (32)
July 2008 (27)
June 2008 (39)
May 2008 (60)
April 2008 (35)
March 2008 (48)
February 2008 (59)
January 2008 (63)
December 2007 (58)
November 2007 (43)
October 2007 (100)
September 2007 (110)
August 2007 (146)
July 2007 (106)
June 2007 (114)
May 2007 (78)
April 2007 (2)
2005
2008
access
analysis
Analysis Services
application
article
awe
backup
backups
baseline
benchmarking
best practice
best practices
bi
blocking
blogs
cache
configuration
cpu
dashboard
data
data warehouse
database
Database Maintenance
database mirroring
databases
dba
dbcc
disaster recovery
disk
disk space
disks
dmv
download
encryption
enterprise
error
fragmentation
hardware
high availability
high cpu
i/o
index
indexes
Indexes From Every Angle
instances
kba
locking
management
memory
microsoft
monitoring
msdn
multiple
new features
optimization
partition
perfmon
performance monitoring
process
profiler
query
replication
reporting
resources
san
scalability
security
server
service pack
services
slow
sql server
SQL Server 2008
ssas
ssis
ssms
statistics
stats
stored procedure
sysmon
system
table
technet
tempdb
testing
tools
trace
transaction log
troubleshoot
tsql
tuning
update statistics
usage
users
version
webcast
windows
x64
How SQL Server 2008 can help to build fast track data warehouse?
Beginning of this year I have posted here about Build your BI skills in fast track data warehouse and based on that I have had few questions and feedback on how best we can take help of SQL Server 2008 features to build the fast track data warehouse....
Published
Fri, Oct 9 2009 2:26
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
performance
,
memory
,
attributes
,
access
,
disk
,
cpu
,
data warehouse
,
fast track
SQL Server database design goals: Memory, Disk and I/O - maximize the scalability with monitoring
Do you consider the I/O whenever a database design project is assigned? It is one of the primary design goals of all database software is to minimize disk I/O because disk reads and writes are among the most resource-intensive operations. Over the time...
Published
Fri, Aug 21 2009 6:47
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
performance
,
memory
,
tools
,
i/o
,
disk
,
statistics
,
monitoring
,
capacity
,
input
SQL Server 2005 and SQL Server 2008 reports 701 errors with large batch sizes
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Edition and SQL Server 2008 Enterprise Edition Notification Contents: New and Major Modifications SQL Server 2005 and SQL Server 2008 reports...
Published
Thu, Aug 20 2009 9:21
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
performance
,
error
,
2008
,
2005
,
reports
,
701
,
batch size
Microsoft Advisory Services Engagement Scenario - SQL Server Performance
Attaining SQL Server performance is not a black magic, you need to asses and implement the scenarios effectively. The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Edition & SQL Server...
Published
Thu, Aug 20 2009 9:19
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
performance
,
kba
,
maintenance
,
best practice
,
advice
Hyper-V and SQL Server Consolidation - whitepaper!
As you may know Hyper-V is the new kid on Windows 2008 block that offers the scalability enhancement using operating system for SQL Server. Here Microsoft IT has combined the power of Hyper-V and SQL Server that provides thousands of SQL Server instances...
Published
Tue, Jul 28 2009 14:25
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
performance
,
security
,
it
,
support
,
scalability
,
Hyper-V
,
virtual machines
SQL Server performance problem, how bad it is or rather I ask how good are you to find the root cause?
I always trust how good your resources are to find out a root cause than how bad the problem is? It is one of the best point of disaster recovery position I wanted to be to get to work on solution on quicker basis than worrying about the impact, the business...
Published
Mon, Jul 27 2009 1:53
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
perfmon
,
performance
,
ssms
,
tools
,
best practices
,
encryption
,
locks
,
baseline
,
benchmarking
,
performance monitoring
Free Microsoft Press eBook offer - Introducing SQL Server 2008
Here is the interesting and fantastic news for the SQL Server users, Microsoft Press is offering eBook about "Introducing Microsoft SQL Server 2008" by Industry Experts & SQL Server MVPs - Greg Low, Peter DeBetta & Mark Whitehorn. *...
Published
Mon, Jun 1 2009 9:55
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
performance
,
mvp
,
download
,
storage
,
ebook
,
high avialability
,
busiiness intelligence
,
windows live
,
programmability
,
offer
Do you know how many Monitoring Tools and Resources available in SQL Server?
Monitoring Tools and Resources are essential for performance tuning & better manageability in SQL Server. Many times the users think that collection and analysis of performance data is not a day-to-day job, also I feel that it is difficult at best...
Published
Mon, Jun 1 2009 2:25
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
performance
,
ssms
,
tools
,
best practices
,
bids
,
monitoring
,
resources
,
readtrace
,
profiller
Proactive caching for Analysis Services databases - performance techniques and better usage
By default SQL Server has a pool of memory that is used to store both execution plans and data buffers. This pool of memory is managed by default within Analysis Services for SQL Server and such percentage of the pool allocated to either execution plans...
Published
Sun, May 31 2009 9:32
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
performance
,
data
,
cache
,
best practices
,
cube
,
Analysis Services
,
rolap
,
molap
,
proactive
,
advantage
SQL Server Edition - which is the best one to choose for your database needs?
When I look at the question, I feel that no direct answer to it! The reason being SQL Server has outgrown into an important enterprise RDBMS product from a simple desktop based database application, but still maintains the ease of installation and use...
Published
Sun, May 17 2009 12:54
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
performance
,
standard
,
best practices
,
edition
,
enterprise
,
statistics
,
monitoring
,
e-learning
SQL Server Performance patterns of a UDF with datetime parameters
There was an interesting discussion about User Defined Fuctions (UDF) performance and patterns, the actual phenomenon is that UDF has got parameters to pass on during the execution. Just to talk about introduction of such options in the SQL Server history...
Published
Mon, May 11 2009 2:10
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
performance
,
best practices
,
function
,
table-valued
,
testing
,
udf
,
user-defined
Troubleshooting SQL Server 2008 Performance Problems
A new whitepaper covering the topic of performance troubleshooting in SQL Server 2008 has now been released. You can download the paper from the following link: http://msdn.microsoft.com/en-us/library/dd672789.aspx...( read more ) Read More...
Published
Sun, Apr 12 2009 15:26
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
performance
,
2008
Sharepoint Technologies - Monthly Technical Rollup
SharePoint Technologies Microsoft Office Protocol Documentation The Office protocol documentation provides technical specifications for Microsoft proprietary protocols that are implemented and used in the Microsoft Office system. http://www.microsoft...
Published
Wed, Apr 1 2009 5:29
by
<P>SqlServer-QA.net</P>
Filed under:
performance
,
microsoft
,
server
,
sharepoint
,
knowledge
,
technology
,
professional
SQL Server Deadlock and Trace Flag 1204 and 1222- a big question every time
I have seen few users out there thinks that Deadlocks in SQL Server is a bug which has not be corrected by Microsoft since its release! Even few times they get think that deadlocks and blocking are similar reactions in SQL Server, a typical situation...
Published
Tue, Mar 17 2009 2:03
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
performance
,
indexes
,
i/o
,
best practices
,
locking
,
deadlock
,
monitoring
,
beginner
Reminder: Live Webcast TODAY! 10 Tips for Performance Monitoring - IDERA
Tired of phone calls from end users complaining about slow SQL Server performance? Tune into this two-part webcast to learn practical tips for proactively monitoring and managing SQL Server performance. In this live series, Greg Robidoux with Edgewood...
Published
Wed, Feb 4 2009 3:01
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
performance
,
dba
,
best practices
,
monitoring
,
webcasts
SQLcheck - a free performance monitoring tool from IDERA
SQLcheck is a free performance monitoring tool for SQL Server databases. It provides basic performance information for a single SQL Server and runs as a secure screensaver or on demand. Monitors key performance metrics Provides a view of processes, agent...
Published
Wed, Jan 21 2009 3:22
by
<P>SqlServer-Qa.net</P>
Filed under:
sql server
,
performance
,
download
,
free
,
idera
,
ownership
,
performance monitoring
Indexes and UPDATE STATISTICS differences and undocumented options - SQL Server 2005
During an Usergroup meeting one user asked the question that why my query is affected with slow performance when the statistics are upto-date? When asked about the indexes the reply was why do you need indexes when you have updated statistics on all the...
Published
Fri, Jan 16 2009 1:32
by
<P>SqlServer-Qa.net</P>
Filed under:
sql server
,
performance
,
indexes
,
query
,
optimization
,
procedure
,
update statistics
,
monitoring
Using SQL Server FORCESEEK table hint to solve PARAMETER SNIFFING issues
Let us talk about few HINTS that can help to optimize the performance of a query, but bear in mind when using an INDEX hint it forces the query optimizer to use only the specified indexes to access the data in the referenced table or view in the query...
Published
Fri, Jan 9 2009 10:57
by
SqlServer-QA.net
Filed under:
sql server
,
performance
,
best practice
,
monitoring
,
index hint
,
recomplie
,
forceseek
Technet events & webcasts - SQL Server related
High Performance Computing (HPC) Traditional computing takes the form of an application running on a server or workstation. All of the commands for the application are processed on the local system. High Performance Computing (HPC) instead uses the processing...
Published
Fri, Jan 9 2009 2:21
by
SqlServer-QA.net
Filed under:
sql server
,
performance
,
technet
,
events
,
change data capture
,
troubleshooting
,
webcasts
Keep SharePoint Growth in Check with Effective Content Lifecycle Management
Make information archival a component of your SharePoint content lifecycle management strategy Organizations are generating large volumes of mission-critical information on Microsoft SharePoint. As hundreds of gigabytes or even terabytes of unstructured...
Published
Mon, Dec 29 2008 12:11
by
SqlServer-QA.net
Filed under:
sql server
,
performance
,
management
,
webcast
,
sharepoint
,
lifecycle
,
archive
1
2
3
4
5
Next >
...
Last »
Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.
zines:andrewbelon.com