Viewing 15 posts - 13,861 through 13,875 (of 49,552 total)
Would this be the database in question?
03/15/2013 07:56:41,spid21s,Unknown,Unable to open the physical file "P:\DB\Prolaw.mdf". Operating system error 3: "3(The system cannot find the path specified.)".
03/15/2013 07:56:41,spid21s,Unknown,Error: 5120<c/> Severity: 16<c/> State:...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2013 at 5:03 pm
Lynn Pettis (3/15/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2013 at 4:09 pm
dcyoung (3/15/2013)
My network guy is thinking it might be that sql server is starting befor ISCSI gets its job done.
Very possible, which is why I want to see the SQL...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2013 at 4:02 pm
Exactly what it says, all logical log files are in use, so there are no empty ones. No empty VLFs = no shrink.
Check log_reuse_wait_desc in sys.databases for why the log...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2013 at 4:01 pm
dcyoung (3/15/2013)
No errors and the same informational messages on my servers that don't have this problem.
Can you post the error log, from startup to the time you offline/online the DB?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2013 at 3:48 pm
SQLCrazyCertified (3/15/2013)
I thought it should truncate the inactive logs after logbackup\shrink are done.
Just like any other database in full recovery, the logs are truncated (marked as reusable) when a log...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2013 at 2:55 pm
That'll be a scheduled job to run on whatever interval you want and update the relevant rows. You're right, this is not for a trigger. A trigger is for when...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2013 at 2:00 pm
If it's allocation contention, doesn't matter how many drives the data files are split over, just the number of files. If you have IO contention that's when you need separate...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2013 at 1:57 pm
I think someone is several miles out of his depth here...
http://www.sqlservercentral.com/Forums/Topic1430383-2799-1.aspx
p.s. I know he needs to partition by date, not region. Trying to get him to realise that as well...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2013 at 1:39 pm
ratheesh4sql (3/15/2013)
Yeah i am planning to do that way.Region wise partitioning:
1. RegionGroup1Current,
2. RegionGroup2Current,
3. RegionGroupCurren
So, when you archive, you archive (move to another table) and delete an entire region at a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2013 at 1:36 pm
cryovenom (3/15/2013)
I'll try setting it to default for memory allocation and see if that goes away.
Will be interesting to see, but memory allocation is the one thing you do...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2013 at 1:28 pm
2013-03-15 15:10:15.10 Server Failed allocate pages: FAIL_PAGE_ALLOCATION 1
That's memory related, might have something to do with the NUMA node configuration, not sure though.
Going to have to consult an expert...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2013 at 1:16 pm
MyDoggieJessie (3/15/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2013 at 1:09 pm
cryovenom (3/15/2013)
Can you offer any assistance, despite the fact that you don't recommend this configuration?
If you post the error log that I asked for, maybe.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2013 at 1:05 pm
ratheesh4sql (3/15/2013)
I want to create 3 partitions Based on the List of region
So the business rule is that you always archive and delete an entire region at a time....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2013 at 1:03 pm
Viewing 15 posts - 13,861 through 13,875 (of 49,552 total)