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
The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure
SQL Server - when to use stored procedures, a big question and think about plan cache?
SQL Server Management Studio - Obtain Misisng Indexes information and its limitations!
How fast you can obtain information about missing indexes? Its easy and quick!
How SQL Server 2008 can help to build fast track data warehouse?
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
February 2010 (2)
January 2010 (11)
December 2009 (4)
November 2009 (3)
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
February 2010 (2)
January 2010 (11)
December 2009 (4)
November 2009 (3)
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
February 2010 (2)
January 2010 (11)
December 2009 (4)
November 2009 (3)
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
February 2010 (2)
January 2010 (11)
December 2009 (4)
November 2009 (3)
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
February 2010 (2)
January 2010 (11)
December 2009 (4)
November 2009 (3)
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
February 2010 (2)
January 2010 (11)
December 2009 (4)
November 2009 (3)
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
February 2010 (2)
January 2010 (11)
December 2009 (4)
November 2009 (3)
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
February 2010 (2)
January 2010 (11)
December 2009 (4)
November 2009 (3)
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
February 2010 (2)
January 2010 (11)
December 2009 (4)
November 2009 (3)
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
February 2010 (2)
January 2010 (11)
December 2009 (4)
November 2009 (3)
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
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
mdx
memory
microsoft
monitoring
msdn
multiple
new features
optimization
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
update statistics
usage
users
version
webcast
windows
x64
The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure
A typical error occurred when a simple SSIS package has been executed to export 500 rows to another SQL instance, not once atleast 3 times! More information on error text from event viewer that has been generated by the 'service; The buffer manager...
Published
Mon, Feb 1 2010 9:38
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
performance
,
data
,
ssis
,
error
,
import
,
integration services
,
export
,
low memory
SQL Server - when to use stored procedures, a big question and think about plan cache?
Every now and then I see this big question from SQL Server users that when to use a stored procedure? Well there is a second part to this question as well, think about caching of such stored procedures There is no such database management software that...
Published
Tue, Jan 26 2010 9:42
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
performance
,
plan
,
maintenance
,
cursor
,
tempdb
,
stored procedure
,
monitoring
,
execution
SQL Server Management Studio - Obtain Misisng Indexes information and its limitations!
It is a common criteria that using Dynamic Management Views (DMVs) you can easily obtain the system & database state on a SQL instance. It may not be easy for a starter DBA to ensure what kind of DMV is used to obtain information on Recent Expensive...
Published
Thu, Jan 14 2010 1:14
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
performance
,
ssms
,
query
,
best practice
,
management studio
,
database tuning advisor
,
execute plan
How fast you can obtain information about missing indexes? Its easy and quick!
On the subject line the process to find the answer is not a short one! By design SQL Server engine takes care when the query optimizer generates a query plan, it analyzes what are the best indexes for a particular filter condition. If the best indexes...
Published
Sun, Nov 22 2009 18:26
by
<P>SqlServer-QA.net</P>
Filed under:
sql server
,
performance
,
indexes
,
dmv
,
best practice
,
execution plan
,
monitoring
,
dbas
,
index hint
,
view server state
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
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