Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Aug 25, 1999

SQL Sam and the Too-Slow Query - Part 1

By Steve Hontz

SQL Sam and the Too-Slow Query - Part 1

Environment: SQL Server 6.5, SP4

A familiar shadow fell across the anti-glare screen of SQL Sam's workstation at Books-R-Us. "Hello, Tulsa," Sam grinned, looking up. "Haven't seen you in a while..."

Tulsa Jones brushed back an errant lock of platinum-blonde hair. "Well, Sam, it's been pretty busy around here since we installed the new Bookworm 2 software upgrade," she said. Tulsa was the manager in charge of all the Books-R-Us customer service representatives. She had provided much of the information behind the database design for Bookworm 2, the application the agents used to handle customer's book orders.

"Yes, there were a few unexpected glitches, but the database seems to running smoothly now," said Sam.

"Thanks to you, Sam. But you know, there is still one problem that pops up every now and then," said Tulsa. "Sometimes the agents report time-out errors when they're waiting to look at the order details for a particular order number. The time-out is thirty seconds, and it doesn't happen often, but none of the agents remember it ever happening before the upgrade."

"Let's take a look," said Sam. "What's the table involved?"

"It's called 'order_details'. There- that's it," she said, pointing at the window Sam had brought up:

"It's keyed by the order number and the item number. When the agent selects a particular order number, the details window shows the individual items in the order."

"Okay, it's time to do a SQL Trace," said Sam.

Continue with SQL Sam and the Too-Slow Query

Go to the solution now!

Back to SQL Sam Cases


Steve Hontz is President of The Bit Corner, Inc., a Phoenix-based consulting firm specializing in Windows NT, C++, and SQL Server development. You can reach him at steve@bitcorner.com.




MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM