Viewing 15 posts - 136 through 150 (of 153 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...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
June 18, 2012 at 1:50 pm
Thanks for clearning that up! 😀
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
June 18, 2012 at 12:19 pm
Nice! I'm glad that worked, that's exactly what happened in my situation as well :w00t:
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
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...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
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...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
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...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
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...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
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.
Does that mean your...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
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...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
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)
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
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...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
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 then?
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
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 have to...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
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...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
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...
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
June 12, 2012 at 6:35 pm
Viewing 15 posts - 136 through 150 (of 153 total)