Author: "Kelly, Andrew J." / Topic: computers - Searchworks@Jio Institute Digital Library Search Results

Searchworks

Select search scope, currently: Articles

Catalog

books, media & more in Jio Institute collections

Articles

journal articles & other e-resources

Your search keyword '"Kelly, Andrew J."' showing total 4 results

Start Over Author "Kelly, Andrew J." Topic computers

4 results on '"Kelly, Andrew J."'

1. The 4 best ways to efficiently address SQL Server performance problems: use wait stats, file stats, top 10 inefficient queries, and plan reuse to streamline your system

Author: Kelly, Andrew J.
Subjects: File servers -- Rankings -- Methods, Database management systems -- Rankings -- Methods, DBMS, DBMS utility, Computers
Abstract: In my travels throughout the world as a SQL Server performance consultant, I find that many people have trouble determining where to start when they're looking for SQL Server performance [...]
Published: 2010

2. Is tempdb affecting your day-to-day SQL Server performance? Some simple investigation is all it takes

Author: Kelly, Andrew J.
Subjects: File servers -- Investigations, Database management systems -- Investigations, DBMS, Company legal issue, DBMS utility, Computers
Abstract: The tempdb database is essential to normal SQL Server operation and is used extensively both by internal system-level SQL Server processes and by user-generated requests. In fact, tempdb is often [...]
Published: 2010

3. Is your physical disk I/O affecting SQL Server performance? Here are three ways to find out

Author: Kelly, Andrew J.
Subjects: File servers, Database management systems, DBMS, DBMS utility, Computers
Abstract: As a performance consultant, I see SQL Server installations that range in size from the tiny to the largest in the world. But one of the most elusive aspects of [...]
Published: 2010

4. Do you have hidden cache problems? Discover how ad hoc queries can adversely affect your SQL server 2005 system

Author: Kelly, Andrew J.
Subjects: File servers, Database management systems, DBMS, DBMS utility, Computers
Abstract: One thing I hate to see while troubleshooting performance problems on clients' systems is a failure to reuse query plans. Before SQL Server can execute a batch file or stored [...]
Published: 2010

Catalog

Books, media, physical & digital resources

See catalog results