Viewing 15 posts - 1 through 15 (of 28 total)
Thanks for your help.
I logged in to the server from the console instead of a Terminal Server and there it was, timezone set to US Time.
Everything is OK now.
Cheers! 😎
October 20, 2008 at 8:58 am
GilaMonster (10/13/2008)
Please run the following and see what you get.SELECT getdate()
EXEC master..xp_cmdshell 'DATE /T'
EXEC master..xp_cmdshell 'TIME /T'
This is what I got today at 18:48 local time (same as the server...
October 18, 2008 at 12:33 pm
Michael F. McCulloch (10/10/2008)
Take a look at the server's time zone setting.Is it correct?
Yes it is.
I've doubled checked everything. Including the default Language.
There's nothing in the server different from all...
October 13, 2008 at 2:46 am
Database Server A is the server with SQL installed. In order to connect to this Instance I need to go to a Terminal Server B because Database Server A does...
October 10, 2008 at 2:15 pm
I checked all the other servers including the Database server because they are all on the same Domain, this means these servers are synchronized.
I already had check the Time on...
October 10, 2008 at 11:20 am
No Perry.
One thing is the SQL version we have installed, another is the time that the T-SQL statement is giving me and the other is the time show in...
October 10, 2008 at 9:03 am
Hello,
I did check the server and confirmed that the time is is correct with all the other machines, but SQL still has that time difference.
I'm clueless here. I've checked the...
October 10, 2008 at 2:16 am
Adi,
I'm comparing the time between this SQL Installation and all the servers in the Domain. This SQL Instance is the only one with this time difference. All the others have...
October 9, 2008 at 9:21 am
Thx for your replies.
I am afraid on using Profiler because my DB's usually are as big as 160GB.
I already have some problems with Deadlocks and don't want to affect even...
July 10, 2008 at 7:00 am
Yes, I thought on using Profiler to get this info, but I wish to use a script together with an Agent. I suspect it will have lesser load on the...
July 10, 2008 at 5:00 am
Tlog backups are done every 15 minutes in the LS.
I've set the Tlogs to be deleted after 7 days.
July 4, 2008 at 5:22 am
Did a new test so I could confirm that the problem was with Log Truncate.
Started a new LS, let it run for a couple of hours and queryed this command:
BACKUP...
June 30, 2008 at 1:25 am
What I ment was, in order to have maximum performance gain from the DB, it should be in memory. Usually around 80% is enough. You can have less memory than...
June 27, 2008 at 8:19 am
Jeff Moden (6/26/2008)
jjssilva (6/26/2008)
Check Buffer Cache values. Also, how big are the Databases?The DB shouldn't take more than 80% of the available RAM.
So... what do you do when you run...
June 27, 2008 at 2:44 am
Check Buffer Cache values. Also, how big are the Databases?
The DB shouldn't take more than 80% of the available RAM.
June 26, 2008 at 4:11 am
Viewing 15 posts - 1 through 15 (of 28 total)