Viewing 15 posts - 136 through 150 (of 152 total)
Maybe you have a non-SQL Server process consuming CPU cycles?
Or a session consuming CPU (run away job :unsure: exectued by SQL Agent) have you checked sp_who2
Something must...
June 18, 2012 at 1:50 pm
Thanks for clearning that up! 😀
June 18, 2012 at 12:19 pm
Nice! I'm glad that worked, that's exactly what happened in my situation as well :w00t:
June 18, 2012 at 12:03 pm
Ibelieve you would need approx size of the index your re/building in tempdb - you can find on msdn formula for index size calcs, but how about dbcc filestatats.or.sp space...
June 18, 2012 at 2:15 am
If you plan to consolidate some, depending on your orgnization/company - you might want to consider putting "like" business entities/groups together.
If you consolidate too much you...
June 15, 2012 at 5:00 pm
Maybe I'm not following your question, but am I assuming correctly that Analysis Services client (in SSMS) does not work ?
Could it be an issue with configuring ports with...
June 15, 2012 at 4:52 pm
Has SQL Server rolled back your installation, or are the SQL Server service accounts still installed - but SQL hasn't started up?
Did you check your error logs (bootstrap logs)?
Also...
June 15, 2012 at 4:44 pm
Thanks for your solution, good to know for the future.
when i'm on the server, in report manager i'm able to bring up http://servername/ReportServer but not http://servername/Reports....
June 15, 2012 at 4:38 pm
Did you get this resolved?
Not sure if you tried to rename the Virtual Directory in Report Manager URL section of reporting services configuration manager.
Change it to...
June 15, 2012 at 1:16 pm
Ignore post - I just mentioned IPs and Ports configurations. (But I re-read and you are using same IP for new server machine)
June 15, 2012 at 12:54 pm
If you're trying to write out the results to a file to log... ( others may have more elegant method)
But one way is to specify an "OUTPUT" parameter in...
June 13, 2012 at 2:58 pm
Wanted to check when you are attempting to access, you are getting 404? (if your response is yes)
How about when you access:
What are results...
June 13, 2012 at 1:45 pm
You could trying using powershell and output results within Job step probably
http://msdn.microsoft.com/en-us/library/cc280490.aspx
Or use xp command shell .. (but that generally is turned off for security purposes-- You will...
June 13, 2012 at 1:34 pm
I noticed you mentioned you couldn't find the error logs, that's odd. Is it possible the vendor that configured the SQL Server placed on a different drive that what...
June 13, 2012 at 12:21 pm
Is there anything in the SQL error logs or Windows event logs that would give any indication what caused the uncontrolled growth?
Another thought if you know of any processes or...
June 12, 2012 at 6:35 pm
Viewing 15 posts - 136 through 150 (of 152 total)