Solved

Error: The specified workload (file or table) is empty

Posted on 2011-09-24
3
770 Views
Last Modified: 2012-05-12
Hello Guys!

  i am running tuning advisor in sql 2008, i have followd the tutorial, but i am getting this...error
"Error: The specified workload (file or table) is empty"...
1. ran against a db
2. ran against one table ( not at all empty).

no help
Bye
0
Comment
Question by:shanj
  • 2
3 Comments
 
LVL 25

Accepted Solution

by:
TempDBA earned 100 total points
ID: 36592138
Can you keep the screen shot of the database tuning advisor GUI that you are using to run the tuning . Just wanted to recheck everything fine there or not?
0
 

Assisted Solution

by:shanj
shanj earned 0 total points
ID: 36592162
I found the error, i truncated a table which i created via profiler.

Thanks anyway
0
 

Author Closing Comment

by:shanj
ID: 36813352
thanks for the reply, at least.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql query 8 51
kill process lock Sql server 9 63
Separate 2 comma delimited columns into separate rows 2 40
What is this datetime? 1 18
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question